Updated on 2025-05-29 GMT+08:00

GS_LOGICAL_DATABASE

GS_LOGICAL_DATABASE records information about available databases.

Table 1 GS_LOGICAL_DATABASE columns

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.