Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: [GENERAL] clone_schema function

Re: [GENERAL] clone_schema function

From
"Michael Librodo "
Date:
I had to modify the portion that copies FK constraint:

https://gist.github.com/mlibrodo/6f246c483e650dc716eba752a9d3c79a

Basically, the issue on my end was that the FK constraints on the
cloned(destination) schema seem to reference the source_schema

Re: [GENERAL] clone_schema function

From
Melvin Davidson
Date:


On Tue, Feb 14, 2017 at 7:46 AM, Michael Librodo <mike.librodo(at)gmail(dot)com> <mike.librodo@gmail.com> wrote:
I had to modify the portion that copies FK constraint:

https://gist.github.com/mlibrodo/6f246c483e650dc716eba752a9d3c79a

Basically, the issue on my end was that the FK constraints on the cloned(destination) schema seem to reference the source_schema



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Michael,
Perhaps you can combine that code with the original by Emanuel '3manuek' and that I modified to be more inclusive
of additional objects. See attached.

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
Attachment