Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.36 USER_ALL_TABLES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.36 USER_ALL_TABLES

The USER_ALL_TABLES view provides information about all tables owned by the current user.

Name

Type

Description

schema_name

TEXT

Name of the schema in which the table belongs.

table_name

TEXT

Name of the table.

tablespace_name

TEXT

Name of the tablespace in which the table resides if other than the default tablespace.

status

VARCHAR2(5)

Included for compatibility only; always set to VALID..

temporary

TEXT

Y if the table is temporary; N if the table is permanent.

Previous PageTable Of ContentsNext Page