Re: pg_restore schema dump to schema with different name

Поиск
Список
Период
Сортировка
Искать
От
Jean-Christophe Boggio
Тема
Re: pg_restore schema dump to schema with different name
Дата
Msg-id
f3d480e2-dbda-83f2-ebbe-2b97e5525e3e@thefreecat.org
Ответ на
Список
Дерево обсуждения
pg_restore schema dump to schema with different name Nagaraj Raj <nagaraj.sf@yahoo.com>
Re: pg_restore schema dump to schema with different name Laurenz Albe <laurenz.albe@cybertec.at>
Re: pg_restore schema dump to schema with different name Jean-Christophe Boggio <postgresql@thefreecat.org>
Re: pg_restore schema dump to schema with different name Nagaraj Raj <nagaraj.sf@yahoo.com>
Re: pg_restore schema dump to schema with different name Laurenz Albe <laurenz.albe@cybertec.at>
Re: pg_restore schema dump to schema with different name "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_restore schema dump to schema with different name Nagaraj Raj <nagaraj.sf@yahoo.com>

> 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.

Or maybe (if you can afford to have source_schema unavailable for some
time) :

* rename source_schema to tmp_source
* import (that will re-create  source_schema)
* rename source_schema to destination_schema
* rename back tmp_source to source_schema


В списке pgsql-performance по дате отправления
От: Laurenz Albe
Дата:
От: Nagaraj Raj
Дата:
FAQ