Documentation → PostgreSQL 8.3

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4

Historical version. PostgreSQL 8.3 reached end of support in February 2013. See the current version for supported releases.

PostgreSQL 8.3.23 Documentation
Prev	Fast Backward	Chapter 44. System Catalogs	Fast Forward	Next

44.45. `pg_indexes`

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

Table 44-45. pg_indexes Columns

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

Prev	Home	Next
`pg_group`	Up	`pg_locks`

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.