pg_indexes

The view pg_indexes provides access to useful information about each index in the database.

Table 1. pg_catalog.pg_indexes

Name	Type	References	Description
schemaname	name	pg_namespace.nspname	Name of schema containing table and index
tablename	name	pg_class.relname	Name of table the index is for
indexname	name	pg_class_internal.relname	Name of index
tablespace	name	pg_tablespace.spcname	Name of tablespace containing index (NULL if default for database)
indexdef	text		Index definition (a reconstructed CREATE INDEX command)