Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-3.x)/ System Catalogs and System Views/ System Catalogs/ PG_ATTRDEF
Updated on 2025-08-19 GMT+08:00
View PDF

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 a column or of a generated expression

adsrc

text

Internal representation of a readable default value or of a generated expression

adgencol

"char"

Specifies whether a column is a generated column. The value s indicates that the column is a generated column, and the value '\0 indicates that the column is a common column. The default value is '\0.
Parent topic: System Catalogs