PG_INDEXES

PG_INDEXES displays information about each index in the database.

**Table 1** PG_INDEXES columns
Name	Type	Reference	Description
schemaname	name	nspname in PG_NAMESPACE	Name of the schema that contains tables and indexes.
tablename	name	relname in PG_CLASS	Name of the table for which the index serves.
indexname	name	relname in PG_CLASS	Index name
tablespace	name	nspname in PG_TABLESPACE	Name of the tablespace that contains the index.
indexdef	text	-	Index definition (a reconstructed CREATE INDEX command).

Parent topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.