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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org