GS_LOGICAL_DATABASE
GS_LOGICAL_DATABASE records information about available databases.
Column |
Type |
Description |
---|---|---|
datname |
name |
Database name. |
datid |
oid |
Database OID. |
csnmin |
bigint |
CSN when a tuple is inserted. |
csnmax |
bigint |
CSN when a tuple is updated or deleted. |
createtime |
timestamp with time zone |
Timestamp when a tuple is inserted. |
originid |
integer |
Source identifier of a tuple. |
datdba |
oid |
Owner of the database, usually the user who created it. |
encoding |
integer |
Character encoding for the database. |
datcollate |
name |
Character type used by the database. |
datctype |
name |
Sequence used by the database. |
dattablespace |
oid |
Default tablespace of the database. |
datcompatibility |
name |
Database compatibility mode. Currently, five compatibility modes are supported: ORA, MYSQL, C, M, and PG, indicating compatibilities with Oracle Database, MySQL, Teradata, M-compatible and Postgres databases, respectively. |
dattimezone |
name |
Database time zone. The default is PRC. |
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