Re: Schema Copy

Поиск
Список
Период
Сортировка
От Justin
Тема Re: Schema Copy
Дата
Msg-id CALL-XeMU3VZHZ-hSn+xE-NHfWN7mRtsLEP3ovXGHxMM4H0uYFw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Schema Copy  (Sonam Sharma <sonams1209@gmail.com>)
Ответы Re: Schema Copy  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Hi Sonam

If you want a copy the data do a Select * into  (newschema.table) from oldschema.table     https://www.postgresql.org/docs/9.1/sql-selectinto.html

If you want to just move the table


Alter Table oldschema.table Set Schema  newschema

On Thu, Dec 5, 2019 at 9:31 AM Sonam Sharma <sonams1209@gmail.com> wrote:
Hi Justin,

What can be done to move the data..

On Thu, Dec 5, 2019, 7:57 PM Justin <zzzzz.graf@gmail.com> wrote:
Hi Sonam

As long as the edited sql script  has been changed from  oldschema.tables  or oldschema.functions etc...  to newschema.functions, newschema.functios etc...

This does not move  data

On Thu, Dec 5, 2019 at 5:07 AM Sonam Sharma <sonams1209@gmail.com> wrote:
Can someone please help in schema copy in same database ?

I have taken db dump of current schema and in the ddl file , I have edited it with new schema.
Will this work?

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

Предыдущее
От: Sonam Sharma
Дата:
Сообщение: Re: Schema Copy
Следующее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: AW: secure deletion of archived logs