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. I doubt that the original idea can be made to work, but this "improvement" will entirely guarantee failure. (Note: the problem is not so much with the names of the objects you're directly creating, as with object cross-references that're embedded in the DDL.) regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers