From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Owen Hartnett <owen(at)clipboardinc(dot)com>, Bernd Helmle <mailings(at)oopsware(dot)de>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Schema-qualified statements in pg_dump output |
Date: | 2008-07-22 16:26:05 |
Message-ID: | 1216743965.6971.129.camel@jd-laptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Zdenek Kotala | 2008-07-22 16:36:13 | Re: [WIP] collation support revisited (phase 1) |
Previous Message | Andrew Dunstan | 2008-07-22 16:25:21 | Re: pltcl_*mod commands are broken on Solaris 10 |