Re: Schema Copy
Justin <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <CALL-XeMU3VZHZ-hSn+xE-NHfWN7mRtsLEP3ovXGHxMM4H0uYFw@mail.gmail.com> |
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 https://www.postgresql.org/docs/current/sql-altertable.html Alter Table oldschema.table Set Schema newschema On Thu, Dec 5, 2019 at 9:31 AM Sonam Sharma <[email protected]> wrote: > Hi Justin, > > What can be done to move the data.. > > On Thu, Dec 5, 2019, 7:57 PM Justin <[email protected]> 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 <[email protected]> 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? >>> >>