PG_INDEXES¶
PG_INDEXES displays access to useful information about each index in the database.
Name | Type | Reference | Description |
---|---|---|---|
schemaname | name | PG_NAMESPACE.nspname | Name of the schema that contains tables and indexes |
tablename | name | PG_CLASS.relname | Name of the table for which the index serves |
indexname | name | PG_CLASS.relname | Index name |
tablespace | name | PG_TABLESPACE.spcname | Name of the tablespace that contains the index |
indexdef | text |
| Index definition (a reconstructed CREATE INDEX command) |