"Anirban Pal" <anirban.pal@xxxxxxxxxxxx> writes: > 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. You need to join through pg_index, specifically its columns indrelid and indexrelid. Try running psql with the -E option and look at the queries it uses to implement "\d Table_name". regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
