The version, I am using is 11.2
On Thu, Dec 5, 2019, 9:29 PM Melvin Davidson wrote:
> > Can someone please help in schema copy in same database ?
>
> A while ago, I created the clone_schema function which will duplicate one
> schema to a new schema with the option to copy or not copy data. Howev
> Can someone please help in schema copy in same database ?
A while ago, I created the clone_schema function which will duplicate one
schema to a new schema with the option to copy or not copy data. However,
since there are two versions depending on the version of PostgreSQL you are
using, and you
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 news
Hi Justin,
What can be done to move the data..
On Thu, Dec 5, 2019, 7:57 PM Justin 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
>
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 wrote:
> Can someone please help in schema copy in same datab
