This page in other versions: 9.0 / 9.1 / 9.2 / 9.3 / 9.4  |  Development versions: devel  |  Unsupported versions: 7.1 / 7.2 / 7.3 / 7.4 / 8.0 / 8.1 / 8.2 / 8.3 / 8.4

3.3. pg_attrdef

This catalog stores column default values. The main information about columns is stored in pg_attribute (see below). Only columns that explicitly specify a default value (when the table is created or the column is added) will have an entry here.

Table 3-3. pg_attrdef Columns

Name Type References Description
adrelid oid pg_class.oid The table this column belongs to
adnum int2   The number of the column; see pg_attribute.pg_attnum
adbin text   An internal representation of the column default value
adsrc text   A human-readable representation of the default value
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group