Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ PG_ATTRDEF
Updated on 2025-06-12 GMT+08:00
View PDF

PG_ATTRDEF

PG_ATTRDEF stores default values of columns.

Table 1 PG_ATTRDEF 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
Parent Topic: System Catalogs