postgresql - 获取表和列 "owning"一个序列

Question

我可以运行以下行:

ALTER SEQUENCE seqName OWNED BY table.id;

如何获取序列的 OWNED BY 设置的“所有者”(在本例中为:table.id)？

Answer 1

您可以使用以下查询:

select s.relname as seq, n.nspname as sch, t.relname as tab, a.attname as col
from pg_class s
  join pg_depend d on d.objid=s.oid and d.classid='pg_class'::regclass and d.refclassid='pg_class'::regclass
  join pg_class t on t.oid=d.refobjid
  join pg_namespace n on n.oid=t.relnamespace
  join pg_attribute a on a.attrelid=t.oid and a.attnum=d.refobjsubid
where s.relkind='S' and d.deptype='a'

它返回所有带有所有者信息的序列。只需在 WHERE 子句中过滤它们即可。