一、PostgreSQL孤儿序列查询

-- 孤儿序列查询
SELECT ns.nspname  AS schema_name
      ,seq.relname AS seq_name
  FROM pg_class AS seq
  JOIN pg_namespace ns
    ON (seq.relnamespace = ns.oid)
 WHERE seq.relkind = 'S'
   AND NOT EXISTS (SELECT *
          FROM pg_depend
         WHERE objid = seq.oid
           AND deptype = 'a')
 ORDER BY seq.relname;

二、PostgreSQL孤儿序列绑定表的字段

alter sequence test_s owned by test_t.id;