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

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.

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.