DB_IND_COLUMNS
DB_IND_COLUMNS displays all index columns accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| index_owner | character varying(64) | Index owner |
| index_name | character varying(64) | Index name |
| table_owner | character varying(64) | Table owner |
| table_name | character varying(64) | Table name |
| column_name | name | Column name |
| column_position | smallint | Position of the column in the index |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.