From: Giulio Orsero <giulioo@pobox.com>
To: pgsql-sql@postgresql.org
Subject: Drop all indexes of a table w/o knowing the index names
Date: Tue, 09 Nov 2004 15:40:39 +0100
Message-ID: <20041109144039.1B2D313346@mail.golden.dom> (raw)
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
table1
index1
index2
index3
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: giulioo@pobox.com
Subject: Re: Drop all indexes of a table w/o knowing the index names
In-Reply-To: <20041109144039.1B2D313346@mail.golden.dom>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox