Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Catalogs/ PG_ATTRDEF
Updated on 2025-08-19 GMT+08:00
PG_ATTRDEF
PG_ATTRDEF records default values of columns.
| Name | Type | Description |
|---|---|---|
| oid | oid | Row identifier (hidden attribute, which must be specified) |
| adrelid | oid | Table to which a column belongs |
| adnum | smallint | Number of columns |
| adbin | pg_node_tree | Internal representation of the default value of the column |
| adsrc | text | Internal representation of the human-readable default value |
| adgencol | "char" | Specifies whether a column is a generated column. The value s indicates that the column is a generated column, and the value '\0 indicates that the column is an ordinary column. The default value is '\0. |
Parent topic: System Catalogs
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
