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. Thanks a lot for help Giovanni