GaussDB-MY_IND_EXPRESSIONS
MY_IND_EXPRESSIONS displays information about function-based expression 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 |
|---|---|---|
| table_owner | character varying(64) | Table owner. |
| table_name | character varying(64) | Table name. |
| index_owner | character varying(64) | Index owner. |
| index_name | character varying(64) | Index name. |
| column_expression | text | Function-based index expression of a specified column. |
| column_position | smallint | Position of a column in an index. |
更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…