From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Melvin Davidson Sent: Wednesday, September 09, 2015 12:31 PM To: pgsql-general@postgresql.org Subject: [GENERAL] clone_schema function
I noted there was an inquiry as to how to copy or clone_schema an entire schema. The standard method for doing that is to 1. pg_dump the schema in plain format 2. edit the dump file and change all occurrences of the schema name 3. reload the dump into the new schema.