PostgreSQL:

REINDEX

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

bottom of page