select nspname as Schemaname,relname as Tablename, tgname as Triggername,case
when tgenabled='O' then 'Enabled' else 'Disabled' end as Trigger_Enabled,
proname as trigerfunctionname from (pg_trigger join pg_class on
tgrelid=pg_class.oid) join pg_proc on (tgfoid=pg_proc.oid) join pg_namespace m
on m.oid=relnamespace
where tgtype not in (5,9,17) and nspname not in
('pg_catalog','information_schema') order by 1,2;