Postgres Pro
Downloads
Home   >   mailing lists

Re: Schema Copy - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Schema Copy
Date
Msg-id CANu8Fixo9XZcQOyW4jJUNrTi9avjMZKZucLGwJrho5ORtCHo5g@mail.gmail.com
Whole thread Raw
In response to Re: Schema Copy  (Justin <zzzzz.graf@gmail.com>)
Responses Re: Schema Copy
List pgsql-general
Tree view
> 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 have not specified which version of PostgreSQL you have, I cannot help you at this time.

On Thu, Dec 5, 2019 at 9:37 AM Justin <zzzzz.graf@gmail.com> wrote:
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?


--
Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: We have to close the cursor or rollback the transaction in case of failure?
Next
From: Sonam Sharma
Date:
Subject: Re: Schema Copy