System Views
This section describes the system views added to RDS for 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot