Re: enhancement to pg_dump: supress columns

On N, 2005-10-13 at 15:13 -0400, Merlin Moncure wrote:
> I have a situation where I need to hack pg_dump not to dump columns with
> a particular name. If this is of interest to the community I can spend
> a little extra effort and work up a patch. I'd be curious to see if
> anyone else thinks this is worthwhile.
>
> Why would I want to do this? I use a global sequence for a database
> wide unique identifier for purposes of locking (to hook into the user
> lock module). This works great but our clients frequently like to make
> copies of data for testing purposes and a dump/reload into a separate
> schema makes a copy of the generated identifier in the database.
>
> Basically, I need a field to revert to default in a dump/reload cycle.
> A command line switch to pg_dump seems the easiest way to handle this.
> A specialized domain qualifier which prevents the column from being
> dumped is perhaps more elegant but more work.

I think that general ability to *exclude* things (schemas, tables,
functions) from pg_dump output would be great:

pg_dump mydb -X schema.view -X "schema.function(int,text,text)" -X
"schema.table.*fieldnamepart*"

--
Hannu Krosing <hannu(at)skype(dot)net>