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

**Table 53.12. `pg_indexes` Columns**

| 
Column Type

Description

 |
| --- |
| 

`schemaname` `name` (references [`pg_namespace`](https://www.postgresql.org/docs/current/catalog-pg-namespace.html "52.32. pg_namespace").`nspname`)

Name of schema containing table and index

 |
| 

`tablename` `name` (references [`pg_class`](https://www.postgresql.org/docs/current/catalog-pg-class.html "52.11. pg_class").`relname`)

Name of table the index is for

 |
| 

`indexname` `name` (references [`pg_class`](https://www.postgresql.org/docs/current/catalog-pg-class.html "52.11. pg_class").`relname`)

Name of index

 |
| 

`tablespace` `name` (references [`pg_tablespace`](https://www.postgresql.org/docs/current/catalog-pg-tablespace.html "52.56. pg_tablespace").`spcname`)

Name of tablespace containing index (null if default for database)

 |
| 

`indexdef` `text`

Index definition (a reconstructed [CREATE INDEX](https://www.postgresql.org/docs/current/sql-createindex.html "CREATE INDEX") command)

 |
