How to know the indexes on a Table

Поиск
Список
Период
Сортировка
От Anirban Pal
Тема How to know the indexes on a Table
Дата
Msg-id AF5DA1B9791741289D2F258AAB14B3C7@central.newgen.local
обсуждение исходный текст
Ответы Re: How to know the indexes on a Table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: How to know the indexes on a Table  (Frank Heikens <frankheikens@mac.com>)
Список pgsql-general
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 origin al 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 los s or damage arising from the use of the information transmitted by this email including damages from virus and further acknowledges that no bin ding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of NSTL.

В списке pgsql-general по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Move PGdata to a different drive
Следующее
От: Thomas Walther
Дата:
Сообщение: Authenticate via SSPI/GSSAPI on Windows Server