目录
1 查看特定表名备注
2 查看全部表名和备注
3 查询全部都表名
4 查看特定表名字段,字段类型,描述
5 查询所有表名称以及字段含义
1 查看特定表名备注
select relname as tabname...select tablename from pg_tables where
schemaname='public' and position('_2' in tablename)=0;
4 查看特定表名字段...,字段类型,描述
select a.attnum,a.attname,concat_ws('',t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod...and a.attrelid=c.oid and a.atttypid=t.oid and d.objoid=a.attrelid and d.objsubid=a.attnum;
5 查询所有表名称以及字段含义...字段备注,concat_ws('',t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from '\(.*\)')) as 列类型 from