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.