1、列出当前数据库所有触发器
select * from pg_trigger;
2、列举出特定表的触发器
select pt.* from pg_class pc join pg_trigger pt on pt.tgrelid=pc.oid where relname='table_name';
3、查询指定模式下的触发器,及其作用的表,使用的触发器函数
select pc.oid tableoid, pc.relname "表名",
pt.oid triggeroid, pt.tgname "触发器名",
pp.oid functionoid, pp.proname "触发器函数名"
from pg_trigger pt
join pg_class pc on pc.oid=pt.tgrelid
join pg_namespace pn on pc.relnamespace = pn.oid
left join pg_proc pp on pt.tgfoid=pp.oid
where tgisinternal=false -- 不是系统创建的
and pn.nspname ='schema_name';
No Leanote account? Sign up now.