Postgres Pro
Downloads
Home   >   mailing lists

Drop all indexes of a table w/o knowing the index names - Mailing list pgsql-sql

From Giulio Orsero
Subject Drop all indexes of a table w/o knowing the index names
Date
Msg-id 20041109144039.1B2D313346@mail.golden.dom
Whole thread Raw
Responses Re: Drop all indexes of a table w/o knowing the index names
List pgsql-sql
Tree view 
7.4.6 on Linux.

I need a way to drop all indexes of a table without knowing the names of the
indexes.

Say I have a table

table1index1index2index3

I don't want to do

drop index1;
drop index2;
drop index3;

but I want

drop <all indexes of table table1>

is this possible? I looked in the manual at pg_index, but couldn't build an
sql string to do it.

Thanks

-- 
giulioo@pobox.com

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: A transaction in transaction? Possible?
Next
From: T E Schmitz
Date:
Subject: Re: tricky GROUP BY / JOIN question