Toad World® Forums

Option to ignore schema name

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.


Hi Sankar - did you get an opportunity to try the option that Petr pointed out?