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.
