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.