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

GS_LOGICAL_CLASS

GS_LOGICAL_CLASS records information about database objects required for logical decoding and the relationships between the database objects.

Table 1 GS_LOGICAL_CLASS columns

Column

Type

Description

relname

name

Table name.

relnamespace

oid

Namespace OID.

relpersistence

"char"

Catalog durability (for example, p indicates a permanent table).

relkind

"char"

Table type (for example, r indicates a relationship).

relnatts

smallint

Number of columns in the table.

relhaspkey

bool

Specifies whether the table has (or has ever had) a primary key index.

relcmprs

tinyint

Compression attribute of a row in a table.

relreplident

"char"

Replica identity replication mode.

spacenode

oid

Tablespace OID.

dbnode

oid

Database OID.

relnode

oid

Identifier of the physical storage file corresponding to the table.

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.

relid

oid

Relationship identifier (table OID).

relowner

oid

Identifier of the table owner.

reltoastrelid

oid

OID of the TOAST table (if any).

relhasoids

boolean

Specifies whether the table has an OID column.

relam

oid

Identifier that indicates the indexing method used by the table.

reloptions

text[]

Additional options for saving the table, stored in text format.

relbucket

oid

Identifier of the hash partitioning bucket to which the table belongs.

parttype

"char"

Specifies whether the table is a partitioned table. p indicates that the table is a partitioned table, and n indicates that the table is not a partitioned table.