pg_restore schema dump to schema with different name

Поиск
Список
Период
Сортировка
От Nagaraj Raj
Тема pg_restore schema dump to schema with different name
Дата
Msg-id 2083887101.547666.1629711847197@mail.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>)
Список pgsql-performance
Hi,

I know I can alter schema name after restoring but the problem is the name already exist and I don't want to touch that existing schema.
The dump type is "custom".



So effectively I want something like.
pg_dump -U postgres --schema "source_schema" --format "c" --create --file "source_schema.bak" my_db
pg_restore -U postgres --exit-on-error --dbname "my_db"  --destination-schema "destination_schema"  

Currently this is not something can do. this functionality is there in oracle. 



Is this future considering to add?  (it would really help for create any test schemas without disturbing current schema. )


Thanks,
Rj

В списке pgsql-performance по дате отправления:

Предыдущее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: pg_restore schema dump to schema with different name