duplicating a schema - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject duplicating a schema
Date
Msg-id 20091129132145.6eb138bf@dawn.webthatworks.it
Whole thread Raw
Responses Re: duplicating a schema
List pgsql-general
I need to create a new schema with all the content in an existing
one, just with a new name.

The way I've found is:
- make a backup
- load it in a dev box
- rename the schema
- make a backup of the new schema
- restore the new schema on the original DB.

Is there a more efficient approach?

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


pgsql-general by date:

Previous
From: Irene Barg
Date:
Subject: Re: vacuumdb -z do a reindex?
Next
From: Craig Ringer
Date:
Subject: Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10