sql - 如何获取与 PostgreSQL 中的 View 或表关联的触发器

Question

我有一个要求，我必须获得与给定表/ View 关联的触发器列表。
谁能帮我在 PostgreSQL 中找到表的触发器？

Answer 1

这将返回你想知道的所有细节

select * from information_schema.triggers

或者如果你想对特定表格的结果进行排序那么你可以尝试

SELECT event_object_table
      ,trigger_name
      ,event_manipulation
      ,action_statement
      ,action_timing
FROM  information_schema.triggers
WHERE event_object_table = 'tableName' -- Your table name comes here
ORDER BY event_object_table
     ,event_manipulation

---

下面将返回有触发器的表名

select relname as table_with_trigger
from pg_class
where pg_class.oid in (
        select tgrelid
        from pg_trigger
        )