The view pg_indexes
provides access to useful information about each index in the database.
Table 50-65. pg_indexes
Columns
Name | Type | References | Description |
---|---|---|---|
schemaname | name |
| Name of schema containing table and index |
tablename | name |
| Name of table the index is for |
indexname | name |
| Name of index |
tablespace | name |
| Name of tablespace containing index (null if default for database) |
indexdef | text | Index definition (a reconstructed CREATE INDEX command) |
Please login to continue.