Getting the indexes of a table

From: "Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Getting the indexes of a table
Date: 2006-04-27 16:49:41
Message-ID: 00f301c66a1a$94186b00$7b00a8c0@taschenrechner
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2006-04-27 17:17:04 Re: Getting the indexes of a table
Previous Message Oscar Rodriguez Fonseca 2006-04-27 15:28:08 Re: error handling