System Views
This section describes the system views added to PostgreSQL Enhanced Edition on the basis of PostgreSQL 11 open source edition.
| 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 |
| 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. |
Last Article: Functions
Next Article: Data Types
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.