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.