PGSQL获取所有表结构

select

col.table_name as 表名,

col.column_name as 字段名,

col.data_type as 字段类型,

des.description as 字段描述

from

information_schema.columns col left join pg_description des on

col.table_name::regclass = des.objoid

and col.ordinal_position = des.objsubid

where

table_schema = 'public'

--and table_name = 'xxx'

order by

col.table_name;