Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 27 Nov 2006 11:27:22 -0300
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
- Follow-Ups:
- Re: Drop All Index
- From: Marcelo Costa
- Re: Drop All Index
- From: Peter Childs
- Re: Drop All Index
- References:
- Drop All Index
- From: Marcelo Costa
- Drop All Index
- Prev by Date: Re: postgres and solaris
- Next by Date: Re: Drop All Index
- Previous by thread: Drop All Index
- Next by thread: Re: Drop All Index
- Indexes: