postgresql - Copy schema and create new schema with different name in the same data base

Question

I there a way to copy the existing schema and generate new schema with another name in the same database in postgres.

Answer 1

Use pg_dump to dump your current schema in a SQL-formated file. Open the file, replace the schemaname with the new name and excute this script in your database to create the new schema and all other objects inside this schema.