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.