我想要查找所有依赖于特定表格的对象(表、视图等),请问我该在PostgreSQL中编写什么查询来实现此目的?
select 'pg_statistics'::regclass; -- 'pg_statistics'
select 2619::regclass; -- 'pg_statistics' too, on my install
# select refclassid::regclass from pg_depend where classid = 'pg_class'::regclass group by refclassid;
refclassid
--------------
pg_namespace
pg_type
pg_class