"Anirban Pal" <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
