Обсуждение: copy schema X to schema Y in the same DB

Поиск
Список
Период
Сортировка

copy schema X to schema Y in the same DB

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

Re: copy schema X to schema Y in the same DB

От
"Shoaib Mir"
Дата:
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