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
|
Список | 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 SonamAs 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 dataOn 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 по дате отправления: