--所有索引列表
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;