pg获取表结构信息

1，获取具体表的字段相关信息

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
order by a.attname;

---

截图实例：

SQL 2

select table_schema,
               table_name,
               column_name,
               ordinal_position,
               column_default,
               data_type,
               udt_name,
               col_description(a.attrelid, a.attnum) as comment
from information_schema.columns sc, pg_class as c, pg_attribute as a
where table_schema = 'schema名称'
and table_name = '表名'
and a.attrelid = c.oid
and a.attname = sc.column_name
and a.attnum > 0
and c.relname = sc.table_name order by sc.column_name;