Hi All;
Is it possible to re-map / rename schemas when doing a schema based restore from a custom formatted dump file. I have a dump I created like this:
pg_dump -Fc --schema=prod_test prod_db > prod_db.dmp
I want to restore it into another cluster, into a db named integ_db but I want the schema in the restored db to be named integ_test instead of prod_test
Is there a way to do this at pg_restore time? without loading into a schema named prod_test and renaming the schema after the restore?
Thanks in advance