GP获取表结构和字段信息

获取GP表结构和字段信息，在特定的场景里，制作数据字典使用

select a.attname                                              as cloumname,
       format_type(a.atttypid, a.atttypmod)                            as cloumtype,
       (case when a.attlen > 0 then a.attlen else a.atttypmod - 4 end) as cloumlen,
       a.attnotnull                                                    as cloumnull,
       d.adsrc                                                         as cloumdefault,
       col_description(a.attrelid, a.attnum)                           as cloumexplain
from pg_class c,
     pg_attribute a
       left join (select a.attname, ad.adsrc
                  from pg_class c,
                       pg_attribute a,
                       pg_attrdef ad
                  where relname = 'T_TEST_TABLE_NAME'
                    and ad.adrelid = c.oid
                    and adnum = a.attnum
                    and attrelid = c.oid) as d on a.attname = d.attname
where c.relname = 'T_TEST_TABLE_NAME'
  and a.attrelid = c.oid
  and a.attnum > 0;