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

GS_LOGICAL_AUTHID

GS_LOGICAL_AUTHID records user information required for logical decoding.

Table 1 GS_LOGICAL_AUTHID columns

Column

Type

Description

rolid

oid

User ID.

rolname

name

Username.

createtime

timestamp with time zone

Timestamp when a tuple is inserted.

csnmin

bigint

CSN when a tuple is inserted.

csnmax

bigint

CSN when a tuple is updated or deleted.

originid

integer

Source identifier of a tuple.

rolkind

"char"

User type.

pdbid

oid

Tenant ID.