gp 索引列表查询，表字段类型，字段注释查询

--所有索引列表
SELECT n.nspname as "Schema", c.relname as "Name", c2.relname as "Table"
FROM pg_catalog.pg_class c
         JOIN pg_catalog.pg_roles r ON r.oid = c.relowner
         LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
         LEFT JOIN pg_catalog.pg_index i ON i.indexrelid = c.oid
         LEFT JOIN pg_catalog.pg_class c2 ON i.indrelid = c2.oid
WHERE c.relkind IN ('i','')
  AND n.nspname NOT IN ('pg_catalog', 'pg_toast', 'pg_aoseg')
  AND c2.relname NOT LIKE '%_prt_%'
ORDER BY 1,2;



--表字段类型，字段注释查询
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;