52.6. pg_attrdef #

The catalog pg_attrdef stores column default expressions and generation expressions. The main information about columns is stored in pg_attribute. Only columns for which a default expression or generation expression has been explicitly set will have an entry here.

Table 52.6. pg_attrdef Columns

Tipo y columna

Descripción

oid oid

Identificador de fila

adrelid oid (hace referencia a pg_class.oid)

La tabla a la que pertenece esta columna

adnum int2 (references pg_attribute.attnum)

El número de la columna

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.