On Mon, 2008-07-21 at 23:53 -0400, Owen Hartnett wrote:
> It would generate a schema dump where all the references to
> <schema_name> were replaced by <masquerade_name>.
Good idea, can I tweak that a bit?
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
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support