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;
取某个表的索引明细
原创文章标签 Postgresql 文章分类 数据库
©著作权归作者所有:来自51CTO博客作者sunxin686的原创作品,请联系作者获取转载授权,否则将追究法律责任
上一篇:Apache反向代理,本地化访问
下一篇:删除exchange误发邮件
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章