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?

Thanks Still in constraint name , i am seeing schema name

Sankar could you send us part of the script where is the problem?
Miroslav stanik

Suddenly i see schema name in view Comparison even though remove container is enabled.