Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.5 ALL_IND_COLUMNS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.5 ALL_IND_COLUMNS

The ALL_IND_COLUMNS view provides information about columns included in indexes on the tables accessible by the current user.

Name

Type

Description

index_owner

TEXT

User name of the index’s owner.

schema_name

TEXT

Name of the schema in which the index belongs.

index_name

TEXT

The name of the index.

table_owner

TEXT

User name of the table owner.

table_name

TEXT

The name of the table to which the index belongs.

column_name

TEXT

The name of the column.

column_position

SMALLINT

The position of the column within the index.

column_length

SMALLINT

The length of the column (in bytes).

char_length

NUMERIC

The length of the column (in characters).

descend

CHAR(1)

Sorted order of the column on disk. Always set to Y (descending); included for compatibility only.

Previous PageTable Of ContentsNext Page