Re: Schema-qualified statements in pg_dump output - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Schema-qualified statements in pg_dump output
Date
Msg-id 1216749653.3894.429.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: Schema-qualified statements in pg_dump output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Tue, 2008-07-22 at 13:35 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > No need to specify the name at pg_dump time.
> > For text files, just use an option to specify whether we change the
> > actual schema name and replace it with the text :PGDUMPSCHEMA.
> 
> pg_restore is in even worse position than pg_dump to make this happen;
> it would not be able to do anything that's smarter than a sed-like
> substitution.

Somebody just needs to check carefully to see what will work. I accept
there is no easy option that is materially better than sed.

I've screwed up a dump with sed, luckily noticed. I'm not playing
Russian Roulette again. The chance of the schema name being stored
somewhere in the database seems high, on reflection.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: [WIP] collation support revisited (phase 1)
Next
From: Simon Riggs
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?