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


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

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

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAkP8fI8ACgkQOO9i6TSuoN3pCQCfbY5X8hChnW STrdHJ7VthBW93
j5oAoIdMLCJtl4zAJ8O5U4Kli0NdyY8T
=E1I0
-----END PGP SIGNATURE-----

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org