GaussDB-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 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 a column in an index. |
| column_length | numeric | Length of the column. For the variable-length type, the value of this field is NULL. |
| char_length | numeric | Maximum length of a column, in bytes. |
| descend | character varying(4) | Specifies whether columns are sorted in descending (DESC) or ascending (ASC) order. |
| collated_column_id | numeric | Not supported. Set it to NULL. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
