Postgres Pro
Downloads
Home   >   mailing lists

Re: copy schema X to schema Y in the same DB - Mailing list pgsql-general

From Shoaib Mir
Subject Re: copy schema X to schema Y in the same DB
Date
Msg-id bf54be870701240232y405068du4e47d30d4563e17a@mail.gmail.com
Whole thread Raw
In response to copy schema X to schema Y in the same DB  (johnf <jfabiani@yolo.com>)
List pgsql-general
Tree view
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@yolo.com> 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

pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: how to read bytea field
Next
From: Bernd Helmle
Date:
Subject: Re: Who is Slony Master/Slave + general questions.