Updated on 2022-08-16 GMT+08:00

System Views

This section describes the system views added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open-source edition.

Table 1 System views

Super Administrator

DBA

USER

ALL_ALL_TABLES

DBA_ALL_TABLES

-

ALL_COL_COMMENTS

-

USER_COL_COMMENTS

-

DBA_DATA_FILES

-

ALL_DIRECTORIES

DBA_DIRECTORIES

-

ALL_INDEXES

DBA_INDEXES

USER_INDEXES

ALL_JOBS

DBA_JOBS

USER_JOBS

ALL_OBJECTS

-

USER_OBJECTS

ALL_PROCEDURES

DBA_PROCEDURES

USER_PROCEDURES

ALL_SOURCE

DBA_SOURCE

USER_SOURCE

ALL_SEQUENCES

DBA_SEQUENCES

USER_SEQUENCES

ALL_TABLES

DBA_TABLES

USER_TABLES

-

DBA_TABLESPACES

USER_TABLESPACE

ALL_TAB_COLUMNS

DBA_TAB_COLUMNS

USER_TAB_COLUMNS

-

DBA_TRIGGERS

USER_TRIGGERS

ALL_USERS

DBA_USERS

-

ALL_VIEWS

DBA_VIEWS

USER_VIEWS

ALL_IND_COLUMNS

DBA_IND_COLUMNS

USER_IND_COLUMNS

ALL_TAB_PARTITIONS

DBA_TAB_PARTITIONS

USER_TAB_PARTITIONS

ALL_PART_TABLES

DBA_PART_TABLES

USER_PART_TABLES

ALL_PART_KEY_COLUMNS

DBA_PART_KEY_COLUMNS

USER_PART_KEY_COLUMNS

ALL_PART_INDEXES

DBA_PART_INDEXES

USER_PART_INDEXES

ALL_TAB_SUBPARTITIONS

DBA_TAB_SUBPARTITIONS

USER_TAB_SUBPARTITIONS

ALL_SUBPART_KEY_COLUMNS

DBA_SUBPART_KEY_COLUMNS

USER_SUBPART_KEY_COLUMNS

Table 2 Common view

View Name

Description

V$SESSION

Displays information related to the current session, such as SID and username.

NLS_SESSION_PARAMETERS

Shows the NLS parameters and values of the current session.

V$SESSION_LONGOPS

Displays the status of database operations that have been running for more than 6 seconds.