On Tue, Jul 22, 2008 at 1:39 AM, Giovanni Nervi <giovanni.nervi@xxxxxxxxx> wrote: > Hi, > > I would like recreate all indexes on a database, the command reindex > is exclusive lock on table so I prefer the method drop index and > create index. Is there a script for extract the command for the create > index? I see pg_dump but it extract all object definitions. I see the > source of pgAdmin for extract the definition of index, so before to > begin to develop of a shell script for extract the definition of all > indexes, I ask to you if this script already exist. start with "select * from pg_indexes" and go from there.
