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
Re: pg_restore schema dump to schema with different name
Список 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 по дате отправления: