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)