Re: A little pg_dump patch - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: A little pg_dump patch
Date
Msg-id 4E775AB2.8030408@dunslane.net
Whole thread Raw
In response to A little pg_dump patch  (Enrico Pirozzi <sscotty71@gmail.com>)
Responses Re: A little pg_dump patch
List pgsql-hackers

On 09/19/2011 10:34 AM, Enrico Pirozzi wrote:
> Hi, I'm Enrico,
> I wrote a little pg_dump patch,
> I have introduced a new option to have a database dump without comments,
> no 'COMMENT ON' are written on the dump if my new option is selected.
>
> If this little piece of code can interest somebody, I'll be happy to
> share it with the community,
>
>

We had a recent discussion about filtering items in pg_dump / 
pg_restore. My personal feeling is that we should provide filtering of 
table data ion pg_dump, and pre-data and post-data sections in both, all 
of which we know there are good and widespread use cases for, but beyond 
that users should filter using pg_dump -F c and pg_restore --use-list. 
If we try to build in every kind of filter any user might want we'll 
just become horribly bloated.

What's the use case for not dumping comments? At first glance it seems a 
very odd thing to do.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Generating a query that never returns
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Generating a query that never returns