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 |
Sequence used by the database. |
datctype |
name |
Character type used by the database. |
dattablespace |
oid |
Default tablespace of the database. |
datcompatibility |
name |
Database compatibility mode. Currently, five compatibility modes are supported: A, B, 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.