Re: Copy entire schema A to a different schema B

On 2/11/19 10:00 AM, Tiffany Thang wrote:
> 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?

Why do you need to use "--format=custom" instead of "--format=plain"?

For example:
$ pg_dump --format=plain --schema-only --schema=A


-- 
Angular momentum makes the world go 'round.