DB_IND_COLUMNS
DB_IND_COLUMNS displays all index columns accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
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 |
Column length |
char_length |
numeric |
Length of a column (character type). |
descend |
character varying(4) |
Sorting mode of a column. The value can be DESC or ASC. |
collated_column_id |
numeric |
Provides the internal serial number of the language sorting columns. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.