I am doing a comparing of postgres database. I see to many difference in view due to schema name is compared. Is there any option to ignore schema name in comparison.
Hello Sankar,
there is an option to remove schema prefix from the script available in Preferences.
This option works so that it removes schema prefix when it matches the schema name. Ie. you have a view in schema A and in tis definition there is
SELECT * FROM A.table, B.table ... etc
It will be modified so that A schema qualifier will be removed.
SELECT * FROM table, B.table ... etc
The other qualifier is not removed as it may make view definition invalid. If that is your case, there is not currently a way to ignore schema qualifiers specifically.
Petr
Hi Sankar - did you get an opportunity to try the option that Petr pointed out?
Thanks Still in constraint name , i am seeing schema name
Sankar could you send us part of the script where is the problem?
thanks
br.
Miroslav stanik
Suddenly i see schema name in view Comparison even though remove container is enabled.