PG_ATTRDEF
PG_ATTRDEF records default values of columns.
Table 1 PG_ATTRDEF 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 | Identifies whether the column is a generated column. A value of 's' indicates that the column is a generated column, and a value of '' indicates that the column is a normal column. The default value is ''. |
openGauss 2024-05-05 00:44:49