Postgres Pro
Downloads
Home   >   mailing lists

Re: drop index - Mailing list pgsql-novice

From A. Kretschmer
Subject Re: drop index
Date
Msg-id 20060222150521.GK30367@webserv.wug-glas.de
Whole thread Raw
In response to drop index  (" Jaromír Kamler" <kamler@centrum.cz>)
List pgsql-novice
Tree view 
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    ===

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: SQL Question
Next
From: Andreas Kretschmer
Date:
Subject: Re: plpgsql-function with timestamp