From: Nagaraj Raj <nagaraj.sf@yahoo.com>
To: Pgsql-performance <pgsql-performance@postgresql.org>
Subject: pg_restore schema dump to schema with different name
Date: Mon, 23 Aug 2021 09:44:07 +0000 (UTC)
Message-ID: <2083887101.547666.1629711847197@mail.yahoo.com> (raw)
References: <2083887101.547666.1629711847197.ref@mail.yahoo.com>
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_dbpg_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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nagaraj.sf@yahoo.com
Subject: Re: pg_restore schema dump to schema with different name
In-Reply-To: <2083887101.547666.1629711847197@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox