Re: Rename Schema or Script DDL only a schema

Поиск
Список
Период
Сортировка
От Olivier Hubaut
Тема Re: Rename Schema or Script DDL only a schema
Дата
Msg-id opr502rzcr94ope3@olivier.amaze.ulb.ac.be
обсуждение исходный текст
Ответ на Rename Schema or Script DDL only a schema  ("kumar" <sgnerd@yahoo.com.sg>)
Список pgsql-sql
On Tue, 6 Apr 2004 14:32:04 +0530, kumar <sgnerd@yahoo.com.sg> wrote:

> Dear Friends,
>
> Postgres 7.3.2 on Linux 8.
>
> I wanna move about 100 tables from one schema to another (within a  
> database). Is possible to do that? Seems pg_dump doesnt have an option  
> to script only the schema.
>
> Else, it possible to rename the schema.
>
> Please shed some light.
>
> Thanks
> Kumar

Not with this version of PG.
v7.4 allows you to rename schema and dump specific schemas.



-- 
Downloading signature ... 99%
*CRC FAILED*
signature aborted


В списке pgsql-sql по дате отправления:

Предыдущее
От: "kumar"
Дата:
Сообщение: Rename Schema or Script DDL only a schema
Следующее
От: "SZŰCS Gábor"
Дата:
Сообщение: could not devise a query plan