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;