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

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