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(at)yolo(dot)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
>