PostgreSQL获取所有表名

最新推荐文章于 2024-09-13 22:29:08 发布

代元培

最新推荐文章于 2024-09-13 22:29:08 发布

阅读量1.2k

点赞数 1

分类专栏： PostgreSQL 文章标签： PostgreSQL gp

本文链接：https://blog.csdn.net/sosemseo/article/details/107848346

版权

PostgreSQL 专栏收录该内容

54 篇文章 2 订阅

订阅专栏

# 获取所有表名及注释
select 
    relname as tabname,
    cast(obj_description(relfilenode,'pg_class') as varchar) as comment 
from pg_class c 
where relkind = 'r' 
and relname not like 'pg_%' 
and relname not like 'sql_%' 
order by relname;

# 过滤掉分表：加条件 and relchecks=0 即可
select 
    relname as tabname,
    cast(obj_description(relfilenode,'pg_class') as varchar) as comment 
from pg_class c 
where relchecks=0 
and relkind = 'r' 
and relname not like 'pg_%' 
and relname not like 'sql_%' 
order by relname;

# 获取字段名、类型、注释、是否为空
SELECT 
    col_description(a.attrelid,a.attnum) as comment,
    format_type(a.atttypid,a.atttypmod) as type,
    a.attname as name, 
    a.attnotnull as notnull   
FROM pg_class as c,pg_attribute as a 
where c.relname = '表名' 
and a.attrelid = c.oid 
and a.attnum>0;