GaussDB-DB_IND_EXPRESSIONS

65 阅读1分钟

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.

NameTypeDescription
index_ownercharacter varying(64)Index owner.
index_namecharacter varying(64)Index name.
table_ownercharacter varying(64)Table owner.
table_namecharacter varying(64)Table name.
column_expressiontextFunction-based index expression of a specified column.
column_positionsmallintPosition of a column in an index.

更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…