Re-create build index SQL
Need the SQL command required to build an existing index? Get it like this:
select pg_get_indexdef('my_index'::regclass);
pg_get_indexdef
--------------------------------------------------------
CREATE UNIQUE INDEX my_index ON my_table USING btree (my_column)
(1 row)