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.
