"Anirban Pal" <anirban....@newgen.co.in> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general