Overview

The pg_attrdef stores information about column default values. It mimics the PostgreSQL system catalog pg_attrdef.

Please note that Oxla doesn’t support the custom types.

Columns

This table is designed for compatibility with tools that require PostgreSQL system tables, so it mostly has dummy data. Please note that not all columns in pg_attrdef are applicable to every type of relation.

The following columns are available for querying in pg_attrdef:

ColumnTypeDescription
oidintThis column represents the row identifier
adrelidintThis column represents the table to which this column belongs
adnumintThis column represents the number of the column within the table
adbinstringThis column represents the default value for the column