About how to query trigger enabled status

[datactrl]

Is that possible to show all triggers enabled status(true/false) within a schema by an SQL query?

[rski]

Query the pg_trigger table and look into tgenabled column.
See here

http://www.postgresql.org/docs/9.0/static/catalog-pg-trigger.html

To look for a trigger defined on the specific schema you should join pg_trigger with pg_class (join on tgrelid=relfile node) and with pg_tables (join on relname=tablena me) and check the value of schemaname.

select pg_trigger.* from pg_trigger,pg_class,pg_tables where
tgrelid=relfilenode and relname=tablename and tableschema=<THE SCHEMA NAME>

[datactrl]

Thanks a lot, rski!

[datactrl]

it's "schemaname " rather than "tableschem a".