pg_indexes

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

Columns 5

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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`schemaname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tablename`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`indexname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`tablespace`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`indexdef`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Definition snapshot: english-manuals:9bc794a46e1126b3d088cc09de3… · English manual source