如果你想看查詢所有表，以及表的 oid 請查看另一篇文章
PostgreSQL 查詢所有表和注釋

查詢某個表的所有字段及其類型和注釋，有2種方式
請注意，也可以通過其他表關(guān)聯(lián)查出，筆者的方法僅保證能使用，但是并不一定是最優(yōu)查詢

通過表名查詢

select c.column_name, c.is_nullable, c.udt_name, col_description(a.attrelid, a.attnum) as comment
from pg_attribute as a
         left join information_schema.columns as c
                   on c.table_name = 'bg_user_record' and a.attname = c.column_name
where a.attrelid = (select oid from pg_class where relname = 'bg_user_record')
  and a.attnum > 0
  and a.atttypid > 0;

結(jié)果展示

image.png

通過oid查詢

select c.column_name, c.is_nullable, c.udt_name, col_description(a.attrelid, a.attnum) as comment
from pg_attribute as a
         left join information_schema.columns as c
                   on c.table_name = (select relname from pg_class where oid = 16529) and a.attname = c.column_name
where a.attrelid = 16529
  and a.attnum > 0
  and a.atttypid > 0;

結(jié)果展示

image.png