Thread: drop index

drop index

From

" Jaromír Kamler"

Date:

22 February 2006, 13:54:11

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:

22 February 2006, 13:56:26

  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:

22 February 2006, 14:00:25

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

msg-19448-18001.dat

Re: drop index

From

"A. Kretschmer"

Date:

22 February 2006, 14:05:23

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