On 11/11/2013 08:59 AM, Rafael Martinez wrote:
* It would be great to be able to tell pg_restore that user1 in the dump will became user2 in the restored/cloned database. The same for the name of the database.
A general ability to rename things would be good. In particular, restoring schema x into schema y or table x into table y would be very useful, especially if you need to be able to compare old with new.
Unfortunately, this would involve a fairly significant change in the design of pg_dump / pg_restore. The stored SQL is currently fairly opaque, and a renaming scheme would probably need to implement instead some sort of placeholder mechanism. That would mean a LOT of work.
cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
