Re: pg_dump vs schemas

Jeff Davis writes:

> Let's say I have a development database, and I want to copy the entire
> schema myapp_dev1 to schema myapp_dev2 on the same database. Currently,
> it's fairly awkward to do that.

One possible way may be:
Dump the source schema.
Remove references to the schema name in the pg_dump file.
Change search_path and restore schema.

Not sure how this would work with the special Fc format. It should work with
the ASCII format.


> How do other people do that? Is it worth trying to add a way for
> pg_restore to rename object?

In the particular case that you mentioned, if pg_dump could be made to not
include the schema name anywhere that should make the process easier.