PG 查询所有表信息、表字段信息

查询所有业务表信息

select * from pg_tables where tablename not like 'pg%' and tablename not like 'sql_%' order by tablename;

 

查询所有业务表名称及表描述

select tablename,obj_description(relfilenode,'pg_class')  from pg_tables  a, pg_class b
where a.tablename = b.relname and a.tablename not like 'pg%' and a.tablename not like 'sql_%' order by a.tablename;

 

查询某表的字段信息

select a.attname as fieldname, col_description(a.attrelid,a.attnum) as comment,format_type(a.atttypid,a.atttypmod) as type, 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;

 

 

---

【Java面试题与答案】整理推荐

• 基础与语法
• 集合
• 网络编程
• 并发编程
• Web
• 安全
• 设计模式
• 框架
• 算法与数据结构
• 异常
• 文件解析与生成
• Linux
• MySQL
• Oracle
• Redis
• Dubbo