#  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)    |