pg_get_indexdef()
pg_get_indexdef(index_oid, column_oid)
index_oid
column_oid
pretty_bool
CREATE TABLE sample_table(col int); CREATE INDEX sample_index ON sample_table(col);
SELECT oid FROM pg_class WHERE relname = 'sample_index';
oid ------ 16387
SELECT pg_get_indexdef(16387);
pg_get_indexdef ------------------------------------------------------- CREATE INDEX sample_index ON public.sample_table(col) (1 row)