Re: Changing schema name when restoring?

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: Changing schema name when restoring?
Дата
Msg-id CAECtzeU-diZPfkqubwiLkwVXp9NLnGsCDA1Hjhb-DQUjpmCEJg@mail.gmail.com
обсуждение исходный текст
Ответ на Changing schema name when restoring?  ("Don O'Hara" <don.ohara@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Don O'Hara"
Дата:
Сообщение: Changing schema name when restoring?
Следующее
От: "drum.lucas@gmail.com"
Дата:
Сообщение: Re: pg_dump limit 1000 rows