How to know the indexes on a Table

From: "Anirban Pal" <anirban(dot)pal(at)newgen(dot)co(dot)in>
To: <pgsql-novice(at)postgresql(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: How to know the indexes on a Table
Date: 2009-06-05 05:56:36
Message-ID: AF5DA1B9791741289D2F258AAB14B3C7@central.newgen.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi all,

Is there any way, to know the name of indexes on a table, defined in a database. I mean can I query something like
Select Index_name from pg_class where relname = "Table_name" . Thanks in advance.

--- Thanks & Reagrds ----
Anirban Pal | Software Engineer
Newgen Software Technologies Ltd.
Contact: (011) 26815467-72 | Extn: 177

Disclaimer :- This e-mail and any attachment may contain confidential, proprietary or legally privileged information. If you are not the original intended recipient and have erroneously received this message, you are prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd (NSTL) accepts no responsibilities for loss or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message S Arvind 2009-06-05 06:08:07 max execution time of query
Previous Message Bruce Momjian 2009-06-05 01:33:42 Re: Accessing pg_controldata information from SQL

Browse pgsql-novice by date

  From Date Subject
Next Message Brent Austin 2009-06-05 06:59:29 self-contained db for osx app
Previous Message Larry Silvermintz 2009-06-05 02:32:30 Update Triggers accessing new values and intercepting.