On Mon, 2021-08-23 at 09:44 +0000, Nagaraj Raj wrote: > 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"
The only way to do that is to create a new database, import the data there, rename the schema and dump again. Then import that dump into the target database. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
