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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot