Re: pg_dump --exclude-table-data - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: pg_dump --exclude-table-data
Date
Msg-id 4EB1BDFF.2060505@dunslane.net
Whole thread Raw
In response to Re: pg_dump --exclude-table-data  (Josh Berkus <josh@agliodbs.com>)
Responses Re: pg_dump --exclude-table-data
List pgsql-hackers

On 09/02/2011 03:15 PM, Josh Berkus wrote:
>> OK, this seems to have some pluses and no negative comments, so it seems
>> worth going forward. Do we want an equivalent pg_restore option?
> I'm not sure it's *as* important for pg_restore, since I can easily use
>   a manifest to avoid restoring data for a single table.  So I guess it's
> a question of "how hard is it to add it?"
>

The short answer is "more work than I want to put in to this."
pg_restore doesn't have any of pg_dump's infrastructure for handling
table name patterns, nor for excluding tables. So I think all that would
remain a TODO. (A good beginner project, maybe).

A slightly updated patch is attached, the main change being that I
removed use of a short option and only support the long name option.
"-D" didn't seem sufficiently mnemonic to me. I'll add this to the
November commitfest, but I'd like to get it committed ASAP as it will
simplify setting up the -pre and -post data patches.

cheers

andrew



Attachment

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: psql setenv command
Next
From: Robert Haas
Date:
Subject: Re: heap vacuum & cleanup locks