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.
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.
Hi Sankar - did you get an opportunity to try the option that Petr pointed out?