PostgreSQL:依赖于给定表的 View /表规则列表

Question

如何找到所有具有依赖于给定表的规则的 View 和表？

我需要这个来找到我必须检查哪些 View 和表是否要更改/删除给定的表。

Answer 1

获取引用给定表 TABLENAME 的 View 或表:

SELECT cl_r.relname AS ref_table
FROM pg_rewrite AS r
JOIN pg_class AS cl_r ON r.ev_class=cl_r.oid
JOIN pg_depend AS d ON r.oid=d.objid
JOIN pg_class AS cl_d ON d.refobjid=cl_d.oid
WHERE cl_d.relkind IN ('r','v') AND cl_d.relname='TABLENAME'
GROUP BY cl_r.relname
ORDER BY cl_r.relname;

我通过反转以下答案来做到这一点:https://stackoverflow.com/a/4337615