GaussDB-DB_IND_EXPRESSIONS
DB_IND_EXPRESSIONS displays information about expression indexes accessible to the current user. 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_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…