pgsql清理表的oids选项

coolclouds

于 2024-08-21 17:57:42 发布

阅读量322

点赞数 1

CC 4.0 BY-SA版权

文章标签： sql

本文链接：https://blog.youkuaiyun.com/coolclouds/article/details/141399819

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. 执行生成脚本