pg_indexes
The view pg_indexes provides access to useful information about each index in the database.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- schemaname, tablename, indexname, tablespace, indexdef
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_indexes provides access to useful information about each index in the database.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| schemaname | name | Nullable | Name of schema containing table and index |
| tablename | name | Nullable | Name of table the index is for |
| indexname | name | Nullable | Name of index |
| tablespace | name | Nullable | Name of tablespace containing index (null if default for database) |
| indexdef | text | Nullable | Index definition (a reconstructed CREATE INDEX command) |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:cd6dc2aa0b35b7a1c717ac6846211ecd26306e41b7d64404970609d862728c7a
Text language: en · catalog-bilingual-repair:cd6dc2aa0b35b7a1c717ac6846211ecd26306e41b7d64404970609d862728c7a