Updated on 2024-06-03 GMT+08:00

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.

Table 1 MY_IND_COLUMNS columns

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. The value is NULL.