postgres oid相关 pg_class：oid与relname互查根据表名称获取其所有属性：

分类: IT文章 • 2025-01-30 15:09:49

SELECT oid FROM pg_class WHERE relname = 'mytable';
SELECT relname FROM pg_class WHERE oid in (16391,16394,16397);

根据表名称获取其所有属性：

SELECT * FROM pg_attribute WHERE attrelid = 'mytable'::regclass;