duplicating a schema

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: <pgsql-general(at)postgresql(dot)org>
Subject: duplicating a schema
Date: 2009-11-29 12:21:45
Message-ID: 20091129132145.6eb138bf@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2009-11-29 13:40:26 Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10
Previous Message Irene Barg 2009-11-29 11:49:22 Re: vacuumdb -z do a reindex?