Documentation → PostgreSQL 7.4

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 7.4 reached end of support in October 2010. See the current version for supported releases.

PostgreSQL 7.4.30 Documentation
Prev	Fast Backward	Chapter 43. System Catalogs	Fast Forward	Next

43.31. `pg_indexes`

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

Table 43-31. 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
`indexdef`	`text`		index definition (a reconstructed creation command)

Prev	Home	Next
System Views	Up	`pg_locks`

Report a documentation issue

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