System Catalogs / System views
pg_indexes
Read the PG 18 manualThe view pg_indexes provides access to useful information about each index in the database.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System views
- Columns in this snapshot
- 5
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 5
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
schemaname | name | Name of schema containing table and index pg_namespace.nspname |
tablename | name | Name of table the index is for pg_class.relname |
indexname | name | Name of index pg_class.relname |
tablespace | name | Name of tablespace containing index (null if default for database) pg_tablespace.spcname |
indexdef | text | Index definition (a reconstructed CREATE INDEX command) |
Column history across versions
Definition snapshot: english-manuals:0c8efaf15b0d91378fdaca5b6a8… · English manual source