Re: Drop All Index

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Marcelo Costa <marcelojscosta(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Drop All Index
Date: 2006-11-27 14:27:22
Message-ID: 20061127142722.GC4432@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Childs 2006-11-27 14:47:59 Re: Drop All Index
Previous Message imad 2006-11-27 13:34:36 Re: postgres and solaris