GS_LOGICAL_ATTRIBUTE
GS_LOGICAL_ATTRIBUTE records information about catalog fields required for logical decoding.
Column |
Type |
Description |
---|---|---|
attrelid |
oid |
RELATION OID that contains the attribute. |
attname |
name |
Attribute name. |
atttypid |
oid |
OID of the data type of the attribute. |
attlen |
smallint |
Attribute length. |
attnum |
smallint |
Attribute ID, which uniquely identifies an attribute in a relationship. |
atthasdef |
boolean |
Specifies whether an attribute has a default value. |
csnmin |
bigint |
CSN when a tuple is inserted. |
csnmax |
bigint |
CSN when a tuple is updated or deleted. |
createtime |
timestamp with time zone |
Timestamp when a tuple is inserted. |
originid |
integer |
Source identifier of a tuple. |
dbnode |
oid |
Database OID. |
attndims |
integer |
If the value is of the array type, the value is the declared dimension number. Otherwise, the value is zero. |
attcacheoff |
integer |
Used for the byte offset of the function cache attribute in the heap tuple. |
attbyval |
boolean |
Specifies whether an attribute is transferred by value. |
attstorage |
"char" |
Attribute storage mode. |
attalign |
"char" |
Alignment mode of an attribute. |
attisdropped |
boolean |
Specifies whether the data is deleted (logically invisible). |
attinitdefval |
bytea |
Default value expression of a storage attribute. |
attcollation |
oid |
Copy of attcollation in PG_ATTRIBUTE of the column type. |
atttypmod |
integer |
Copy of atttypmod in PG_ATTRIBUTE of the column type. |
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