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 <[EMAIL PROTECTED]> 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