取某个表的索引明细

select a.relname as indexname,b.attname as colname from pg_class as a,(select attname,attrelid from pg_attribute where attrelid in (select oid from pg_class where relname in (SELECT c.relname AS index_name FROM (SELECT relname,indexrelid FROM pg_index i,pg_class c WHERE c.relname = 'sku_attributes' AND indrelid = c.oid) t,pg_index i,pg_class c WHERE t.indexrelid = i.indexrelid AND i.indexrelid = c.oid))) as b where a.oid=b.attrelid group by indexname,colname;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!