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