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