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

Поиск

Список

Период

Сортировка

copy schema X to schema Y in the same DB

От

johnf

Дата:

23 января 2007 г., 17:50:26

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"

Дата:

24 января 2007 г., 06:32:52

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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

copy schema X to schema Y in the same DB

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