Drop Index and Create Index - Mailing list pgsql-general

From Giovanni Nervi
Subject Drop Index and Create Index
Date
Msg-id 73960e820807220039y551b2542t53232d99bd24ccff@mail.gmail.com
Whole thread Raw
Responses Re: Drop Index and Create Index
List pgsql-general
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

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: ERROR: could not open relation with OID 49152
Next
From: "Scott Marlowe"
Date:
Subject: Re: Drop Index and Create Index