Postgres Pro
Downloads
Home   >   mailing lists

pg_restore schema dump to schema with different name - Mailing list pgsql-performance

From Nagaraj Raj
Subject pg_restore schema dump to schema with different name
Date
Msg-id 2083887101.547666.1629711847197@mail.yahoo.com
Whole thread Raw
Responses Re: pg_restore schema dump to schema with different name
Re: pg_restore schema dump to schema with different name
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: "ldh@laurent-hasson.com"
Date:
Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Next
From: Laurenz Albe
Date:
Subject: Re: pg_restore schema dump to schema with different name