Re: schema diff tool problem with owner statements

2021-11-15 Thread Akshay Joshi
; TABLESPACE pg_default; >> >> ALTER TABLE IF EXISTS public.tablename >> OWNER to devschema; >> >> >> When I run the script on testschema, I don't want it trying to alter the >> owner of the table because that statement will fail anyway. >> >

Re: schema diff tool problem with owner statements

2021-11-12 Thread postgresql
cript on testschema, I don't want it trying to alter the owner of the table because that statement will fail anyway. I found a setting in "preferences" called "ignore owner", and set it to true (If set to True, then the Schema Diff tool ignores the own

Re: schema diff tool problem with owner statements

2021-11-11 Thread Akshay Joshi
he table because that statement will fail anyway. > > I found a setting in "preferences" called "ignore owner", and set it to > true (If set to True, then the Schema Diff tool ignores the owner while > comparing the objects.) > > However, this setting has

schema diff tool problem with owner statements

2021-11-11 Thread postgresql
quot;, and set it to true (If set to True, then the Schema Diff tool ignores the owner while comparing the objects.) However, this setting has no effect.  The alter table statements still get generated, and I am left to remove them manually. If there is something I'm doing wrong please

Schema diff tool

2020-08-12 Thread Alexander Smyslov
Is it possible to add a command line interface (CLI) to pgadmin4 to use schema diff in scripts (like apgdiff)?