Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Catalogs/ PG_ATTRDEF
Updated on 2025-10-09 GMT+08:00
PG_ATTRDEF
PG_ATTRDEF stores default values of columns.
| Column | Type | Description |
|---|---|---|
| adrelid | OID | Table to which the column belongs |
| adnum | Smallint | Column No. |
| adbin | pg_node_tree | Internal representation of the column's default value |
| adsrc | Text | Internal representation of the human-readable default value |
| adbin_on_update | pg_node_tree | Internal representation of the value of on_update_expr |
| adsrc_on_update | Text | Internal representation of the human-readable value of on_update_expr |
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.
