MY_IND_COLUMNS
MY_IND_COLUMNS displays column information about all indexes accessible to the current user. It is accessible to all users. This view exists in both PG_CATALOG and SYS schema.
| 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. |
| column_length | numeric | Length of the column. For the variable-length type, its value is NULL. |
| char_length | numeric | Maximum length of a column, in bytes. |
| descend | character varying | Specifies whether columns are sorted in descending (DESC) or ascending (ASC) order. |
| collated_column_id | numeric | Not supported. Its value is NULL. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
