Getting the indexes of a table - Mailing list pgsql-novice

From Christian Hofmann
Subject Getting the indexes of a table
Date
Msg-id 00f301c66a1a$94186b00$7b00a8c0@taschenrechner
Whole thread Raw
Responses Re: Getting the indexes of a table  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Hello,

I want to get the indexes that are installed in one table.
I looked at the information_schema but there was nothing to use.

I am looking for something like

SELECT column_name, index_name FROM ... WHERE table_name = 'abc'

How should my query look?

Thank you,

Christian





pgsql-novice by date:

Previous
From: Oscar Rodriguez Fonseca
Date:
Subject: Re: error handling
Next
From: Andreas Kretschmer
Date:
Subject: Re: Getting the indexes of a table