Re: copy schema X to schema Y in the same DB

["Shoaib Mir" <shoaibmir@xxxxxxxxx>]

I think the way of doing that will be taking a schema backup using pg_dump -n option and then restoring that again in the same database using a different schema name with psql.

----------------
Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)

On 1/24/07, johnf <jfabiani@xxxxxxxx> wrote:

Hi,
I would like to copy a schema X to a new schema Y within the same database.
Is this possible?
--
John Fabiani

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq