Updated on 2023-10-31 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

Number of the column

adbin

pg_node_tree

Internal representation of the default value of the column

adsrc

text

Internal representation of the readable default value