Copy entire schema A to a different schema B - Mailing list pgsql-general

From Tiffany Thang
Subject Copy entire schema A to a different schema B
Date
Msg-id CAB_W-NMjRS4ah_txcF=pZmYA_KfZLm+mT5eL26-az+xTHEdXcA@mail.gmail.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Martín Fernández
Date:
Subject: Re: Promote replica before being able to accept connections
Next
From: Adrian Klaver
Date:
Subject: Re: Copy entire schema A to a different schema B