Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT i.relname as indname,
- i.relowner as indowner,
- idx.indrelid::regclass,
- am.amname as indam,
- idx.indkey,
- ARRAY(
- SELECT pg_get_indexdef(idx.indexrelid, k + 1, true)
- FROM generate_subscripts(idx.indkey, 1) as k
- ORDER BY k
- ) as indkey_names,
- idx.indexprs IS NOT NULL as indexprs,
- idx.indpred IS NOT NULL as indpred
- FROM pg_index as idx
- JOIN pg_class as i
- ON i.oid = idx.indexrelid
- JOIN pg_am as am
- ON i.relam = am.oid;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement