On Tue, 2008-07-22 at 13:35 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> 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.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
