Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Logical Decoding/ GS_LOGICAL_ATTRDEF
Updated on 2025-05-29 GMT+08:00
View PDF
Share

GS_LOGICAL_ATTRDEF

GS_LOGICAL_ATTRDEF records the default values of storage columns required for logical decoding.

Table 1 GS_LOGICAL_ATTRDEF columns

Column

Type

Description

adid

oid

Identifier of an attribute descriptor.

adrelid

oid

OID of the table to which the catalog belongs.

adnum

smallint

Attribute number.

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.

dbnode

oid

Database OID.

adbin

pg_node_tree

Expression of the default value.

adgencol

"char"

Specifies whether a column is a GENERATED column.
Parent topic: Logical Decoding