Re: enhancement to pg_dump: supress columns - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: enhancement to pg_dump: supress columns
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD5BA@Herge.rcsinc.local
Whole thread Raw
In response to enhancement to pg_dump: supress columns  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-hackers
> 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*"


hmm, ok, that works.  Also schema.domain

Merlin


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] [BUGS] BUG #1962: ECPG and VARCHAR
Next
From: John DeSoi
Date:
Subject: Re: Request for a "force interactive mode" flag (-I) for psql