greenplum 获取表结构

greenplum 表一旦多起来，使用navicat打开表机构会很慢很慢，单是你又需要查看表结构。这时候可以使用sql语句来查看。

替换tableName 即可

SELECT
A .attname AS field,
T .typname AS TYPE
FROM
pg_class C,
pg_attribute A,
pg_type T
WHERE
C .relname = 'tableName'
AND A .attnum > 0
AND A .attrelid = C .oid
AND A .atttypid = T .oid
ORDER BY
A .attnum;