Обсуждение: Drop Index and Create Index

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

On Tue, Jul 22, 2008 at 1:39 AM, Giovanni Nervi
<giovanni.nervi@gmail.com> 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.