Thread: Drop All Index
View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 06:51 AM
Alvaro Herrera
 
Posts: n/a
Default Re: Drop All Index

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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote