Re: Changing schema name when restoring? - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Changing schema name when restoring?
Date
Msg-id CAECtzeU-diZPfkqubwiLkwVXp9NLnGsCDA1Hjhb-DQUjpmCEJg@mail.gmail.com
Whole thread Raw
In response to Changing schema name when restoring?  ("Don O'Hara" <don.ohara@gmail.com>)
List pgsql-admin
2016-03-03 19:41 GMT+01:00 Don O'Hara <don.ohara@gmail.com>:
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. 

Nope, no nicer way.


--

pgsql-admin by date:

Previous
From: "Don O'Hara"
Date:
Subject: Changing schema name when restoring?
Next
From: "drum.lucas@gmail.com"
Date:
Subject: Re: pg_dump limit 1000 rows