pg_attrdef

The catalog pg_attrdef stores column default expressions and generation expressions.

Columns 4

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`adrelid`	`oid`	The table this column belongs to pg_class.oid
`adnum`	`int2`	The number of the column pg_attribute.attnum
`adbin`	`pg_node_tree`	The column default or generation expression, in nodeToString() representation. Use pg_get_expr(adbin, adrelid) to convert it to an SQL expression.

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`adrelid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`adnum`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`adbin`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`adsrc`	●	●	●	●	●	●	●	●	●	·	·	·	·	·	·	·	·	·

Version history 4

Definition snapshot: english-manuals:0ab0946153655003cbe811793bc… · English manual source