From: | "Marcelo Costa" <marcelojscosta(at)gmail(dot)com> |
---|---|
To: | "Marcelo Costa" <marcelojscosta(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Drop All Index |
Date: | 2006-11-27 16:36:41 |
Message-ID: | c13f2d590611270836mc6c20coc7bb7bc203d9e7c6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi, Alvaro, thanks, I make a function to do this.
[],s
Marcelo.
2006/11/27, Alvaro Herrera <alvherre(at)commandprompt(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Wilson | 2006-11-28 10:00:37 | Problem restoring with pg_dump |
Previous Message | Alvaro Herrera | 2006-11-27 14:59:42 | Re: Drop All Index |