Updated on 2024-09-30 GMT+08:00

PG_ATTRDEF

PG_ATTRDEF stores default values of columns.

Table 1 PG_ATTRDEF columns

Name

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