Thread: Get info about indexes

Get info about indexes

From

AlannY

Date:

17 March 2008, 15:12:01

Hello, there.

I need a method of extracting information about indexes of any table
from information_schema.

Have you any suggestions?

Thank you.

Re: Get info about indexes

From

Tom Lane

Date:

17 March 2008, 15:32:42

AlannY <m@alanny.ru> writes:
> I need a method of extracting information about indexes of any table
> from information_schema.

There is nothing about indexes in the information_schema (this is not
a bug, it's an intentional decision by the standards committee).
If you want to know about indexes you'll need to look directly at the
system catalogs.

You can find out about unique/primary-key constraints from
information_schema, but that's not quite the same ...

            regards, tom lane

Re: Get info about indexes

From

"A. Kretschmer"

Date:

17 March 2008, 15:46:43

am  Mon, dem 17.03.2008, um 17:07:20 +0300 mailte AlannY folgendes:
> Hello, there.
>
> I need a method of extracting information about indexes of any table
> from information_schema.
>
> Have you any suggestions?

Yes, http://www.alberton.info/postgresql_meta_info.html


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net