Re: Drop All Index - Mailing list pgsql-admin

From Marcelo Costa
Subject Re: Drop All Index
Date
Msg-id c13f2d590611270836mc6c20coc7bb7bc203d9e7c6@mail.gmail.com
Whole thread Raw
In response to Re: Drop All Index  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Hi, Alvaro, thanks, I make a function to do this.

[],s

Marcelo.

2006/11/27, Alvaro Herrera <alvherre@commandprompt.com>:
Marcelo Costa wrote:
> Hi to all,
>
> Anybody can help me how to proced to delete all index from my database,
> exists any command to this ?

Sure, you can create a PL/pgSQL function that loops around a "select
relname from pg_class where relkind='i' AND ..." and then issues DROP
INDEX for each (or you can do it in shell).  Be careful to include a
clause to select only indexes that are not in system catalogs!

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support



--
Marcelo Costa

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Drop All Index
Next
From: Peter Wilson
Date:
Subject: Problem restoring with pg_dump