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 o
> 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
us
dschema.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 database ?
>>>
s 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 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 wrote:
> Can someone please help in schema copy in s
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?