System Catalogs
pg_attrdef
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
:
Column | Type | Description |
---|---|---|
oid | int | This column represents the row identifier |
adrelid | int | This column represents the table to which this column belongs |
adnum | int | This column represents the number of the column within the table |
adbin | string | This column represents the default value for the column |