Re: schema diff tool problem with owner statements

2021-11-15 Thread Akshay Joshi
Hi On Fri, Nov 12, 2021 at 8:47 PM wrote: > Thanks for the reply, comment embedded below: > On 11/11/21 11:58 PM, Akshay Joshi wrote: > > Hi > > On Fri, Nov 12, 2021 at 12:45 AM wrote: > >> I'm trying to compare 2 schemas (devschema is the source and testschema >> is the target) and generate a

Re: schema diff tool problem with owner statements

2021-11-12 Thread postgresql
Thanks for the reply, comment embedded below: On 11/11/21 11:58 PM, Akshay Joshi wrote: Hi On Fri, Nov 12, 2021 at 12:45 AM wrote: I'm trying to compare 2 schemas (devschema is the source and testschema is the target) and generate a script that can be run on the target that

Re: schema diff tool problem with owner statements

2021-11-11 Thread Akshay Joshi
Hi On Fri, Nov 12, 2021 at 12:45 AM wrote: > I'm trying to compare 2 schemas (devschema is the source and testschema > is the target) and generate a script that can be run on the target that > will create the missing tables. I ran the schema diff, and it generated > items like this: > > CREATE

schema diff tool problem with owner statements

2021-11-11 Thread postgresql
I'm trying to compare 2 schemas (devschema is the source and testschema is the target) and generate a script that can be run on the target that will create the missing tables.  I ran the schema diff, and it generated items like this: CREATE TABLE IF NOT EXISTS tablename ( fields, etc ) TABLESP