GS_LOGICAL_CLASS
GS_LOGICAL_CLASS records information about database objects required for logical decoding and the relationships between the database objects.
|
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.