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
Ответ на
Re: pg_restore schema dump to schema with different name (Laurenz Albe)
Список
Дерево обсуждения
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 по дате отправления