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

GS_LOGICAL_ATTRIBUTE

GS_LOGICAL_ATTRIBUTE records information about catalog fields required for logical decoding.

Table 1 GS_LOGICAL_ATTRIBUTE columns

Column

Type

Description

attrelid

oid

RELATION OID that contains the attribute.

attname

name

Attribute name.

atttypid

oid

OID of the data type of the attribute.

attlen

smallint

Attribute length.

attnum

smallint

Attribute ID, which uniquely identifies an attribute in a relationship.

atthasdef

boolean

Specifies whether an attribute has a default value.

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.

attndims

integer

If the value is of the array type, the value is the declared dimension number. Otherwise, the value is zero.

attcacheoff

integer

Used for the byte offset of the function cache attribute in the heap tuple.

attbyval

boolean

Specifies whether an attribute is transferred by value.

attstorage

"char"

Attribute storage mode.

attalign

"char"

Alignment mode of an attribute.

attisdropped

boolean

Specifies whether the data is deleted (logically invisible).

attinitdefval

bytea

Default value expression of a storage attribute.

attcollation

oid

Copy of attcollation in PG_ATTRIBUTE of the column type.

atttypmod

integer

Copy of atttypmod in PG_ATTRIBUTE of the column type.