Hi,
I know I can alter schema name after restoring but the problem is the name already exist and I don't want to touch that existing schema.
The dump type is "custom".
So effectively I want something like.
pg_dump -U postgres --schema "source_schema" --format "c" --create --file "source_schema.bak" my_db
pg_restore -U postgres --exit-on-error --dbname "my_db" --destination-schema "destination_schema"
Currently this is not something can do. this functionality is there in oracle.
Is this future considering to add? (it would really help for create any test schemas without disturbing current schema. )
Thanks,
Rj
