Is there a way to reiindex whole pg_catalog instead of reindexing each table?
You can achieve this by using below command::
postgres@raghu:/opt/PostgreSQL/8.3/bin$ ./reindexdb -s test -p 5433
[or]
postgres=# reindex system postgres;
--Raghu Ram
-- Łukasz Brodziak "What if everyting around You isn't quite as it seems, What if all the world You think You know is an inelaborate dream When You look at Your reflection is that all you want it to be What if You could look right through the cracks Would You find Yourself...... Find Yourself afraid to see"