Thread: drop index

drop index

From
" Jaromír Kamler"
Date:
Hallo,
I created some indexes and now i want drop them, but I forgetten it's names. How I can find them?

Thanks, Jaromir Kamler


Re: drop index

From
Charley Tiggs
Date:
  Jaromír Kamler wrote:
> Hallo,
> I created some indexes and now i want drop them, but I forgetten it's names. How I can find them?
>
> Thanks, Jaromir Kamler


use "\d table_name" within psql to view a description of the table.  At
the bottom are a list of indexes that are attached to the table.

Charley


Re: drop index

From
Christoph Frick
Date:
On Wed, Feb 22, 2006 at 02:56:54PM +0100,  Jaromír Kamler wrote:

> I created some indexes and now i want drop them, but I forgetten it's
> names. How I can find them?

\di shows all indices of a database

--
cu

Attachment

Re: drop index

From
"A. Kretschmer"
Date:
am  22.02.2006, um 14:56:54 +0100 mailte  Jaromír Kamler folgendes:
> Hallo,
> I created some indexes and now i want drop them, but I forgetten it's names. How I can find them?

In psql cou can see all Indexes for a table with \d <tablename>


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===