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
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
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 ===