Schema Copy

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?

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?

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?

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

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 <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!