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

From Joshua D. Drake
Subject Re: Schema-qualified statements in pg_dump output
Date
Msg-id 1216743965.6971.129.camel@jd-laptop
Whole thread Raw
In response to Re: Schema-qualified statements in pg_dump output  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Tue, 2008-07-22 at 16:58 +0100, Simon Riggs wrote:
> On Mon, 2008-07-21 at 23:53 -0400, Owen Hartnett wrote:

> 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_dump --relocateable-schema (or alternate option name)
> 
> Then when we reload, we just run
> 
>     psql -f pgdump.file -v PGDUMPSCHEMA=newlocation


I like the idea but would prefer no shell variable (I assume that is
what you are using above). Why not just -X target-schema=newlocation
or something like that?

Joshua D. Drake

-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pltcl_*mod commands are broken on Solaris 10
Next
From: Markus Wanner
Date:
Subject: Re: Plans for 8.4