Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Views> PG_INDEXES
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) |
Parent topic: System Views
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.