PostgreSQL | Show Index Query

[c9s]

SELECT t.relname as table_name, i.relname as index_name, a.attname as column_name
FROM pg_class t 
LEFT JOIN pg_index ix ON (t.oid = ix.indrelid) 
LEFT JOIN pg_class i ON (i.oid = ix.indexrelid) 
LEFT JOIN pg_attribute a ON (a.attrelid = t.oid ) 
WHERE 
    a.attnum = ANY(ix.indkey) AND t.relkind = 'r'
ORDER BY table_name, index_name;