pgsql清理表的oids选项

 1. 生成脚本

SELECT
  n.nspname as "Schema",
  c.relname as "Table",
  c.relhasoids as "With OIDs", 'ALTER TABLE '|| n.nspname ||'.' || c.relname || '  SET WITHOUT OIDS;'
FROM
  pg_class c
  JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE
  c.relkind = 'r' and n.nspname <>'pg_catalog' and n.nspname <> 'topology'  
  AND c.relhasoids = 't';

2. 执行生成脚本