Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.40 USER_IND_COLUMNS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.40 USER_IND_COLUMNS

The USER_IND_COLUMNS view provides information about all columns referred to in indexes on tables that are owned by the current user.

Name

Type

Description

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