copy schema X to schema Y in the same DB

Started by johnfabout 19 years ago2 messagesgeneral
Jump to latest
#1johnf
jfabiani@yolo.com

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

#2Shoaib Mir
shoaibmir@gmail.com
In reply to: johnf (#1)
Re: copy schema X to schema Y in the same DB

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)

Show quoted text

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