REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ]
REINDEX INDEX my_index; REINDEX TABLE my_table; $ export PGOPTIONS="-P" $ psql broken_db ... broken_db=> REINDEX DATABASE broken_db; broken_db=> \q
