Changing schema name when restoring?

From: "Don O'Hara" <don(dot)ohara(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Changing schema name when restoring?
Date: 2016-03-03 18:41:52
Message-ID: CAGKCf=ik=1u5n9jtGUXpkfYpC_-VcQAwjewimkCvthajTNj+Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I don't see anything in the documentation for pg_restore, but was curious
if there is any way to restore to a schema name that is different from what
it was unloaded from. I.E. I'd like to generate a TOC list using pg_restore
and edit the schema name in that.

Generating plain text output and editing the file is not an option due to
dataset size.

I have been restoring to the same schema name, then renaming the schema,
but was looking if there are other ways to do it.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2016-03-03 20:38:21 Re: Changing schema name when restoring?
Previous Message Dave Johansen 2016-03-03 15:43:59 Does max_standby_streaming_delay delay all WAL commits?