Copy entire schema A to a different schema B

Поиск
Список
Период
Сортировка
От Tiffany Thang
Тема Copy entire schema A to a different schema B
Дата
Msg-id CAB_W-NMjRS4ah_txcF=pZmYA_KfZLm+mT5eL26-az+xTHEdXcA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Copy entire schema A to a different schema B  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Copy entire schema A to a different schema B  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-general
Hi,
To copy the source schema A to target schema B in the same database in PG10.3, I use psql to dump schema A and manually removes anything specific to the schema in the text dump file before importing into schema B. How do I achieve the same exporting from Schema A and importing into schema B using pg_dump with the -Fc option? Since the dump file generated is binary, I could not make modifications to the file. Is the procedure the same in version 11?

Thank.

Tiff

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

Предыдущее
От: Martín Fernández
Дата:
Сообщение: Re: Promote replica before being able to accept connections
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Copy entire schema A to a different schema B