GaussDB-MY_IND_EXPRESSIONS

44 阅读1分钟

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.

NameTypeDescription
table_ownercharacter varying(64)Table owner.
table_namecharacter varying(64)Table name.
index_ownercharacter varying(64)Index owner.
index_namecharacter varying(64)Index 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…