Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.31 DBA_TABLES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.31 DBA_TABLES

The DBA_TABLES view provides information about all tables in the database.

Name

Type

Description

owner

TEXT

User name of the table’s owner.

schemaname

TEXT

Name of the schema in which the table belongs.

table_name

TEXT

Name of the table.

table_space

TEXT

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

status

CHAR(5)

Included for compatibility only; always set to VALID.

temporary

CHAR(1)

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

Previous PageTable Of ContentsNext Page