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.