(select attname from pg_attribute where attrelid = conrelid and attnum = conkey[1]),

coninhcount, conislocal, connoinherit

from pg_constraint where contype in ('n','p') and

conrelid in ('inh_child'::regclass, 'inh_parent'::regclass);

conrelid in ('inh_child'::regclass, 'inh_parent'::regclass)

order by 1, 2;

conrelid | conname | contype | conkey | attname | coninhcount | conislocal | connoinherit

------------+-----------------------+---------+--------+---------+-------------+------------+--------------

inh_parent | inh_parent_a_not_null | n | {1} | a | 0 | t | f

(select attname from pg_attribute where attrelid = conrelid and attnum = conkey[1]),

coninhcount, conislocal, connoinherit

from pg_constraint where contype in ('n','p') and

conrelid in ('inh_child'::regclass, 'inh_parent'::regclass);

conrelid in ('inh_child'::regclass, 'inh_parent'::regclass)

order by 1, 2;

conrelid | conname | contype | conkey | attname | coninhcount | conislocal | connoinherit

------------+-----------------------+---------+--------+---------+-------------+------------+--------------

inh_parent | inh_parent_a_not_null | n | {1} | a | 0 | t | f

(select attname from pg_attribute where attrelid = conrelid and attnum = conkey[1]),

coninhcount, conislocal, connoinherit

from pg_constraint where contype in ('n','p') and

conrelid in ('inh_child'::regclass, 'inh_parent'::regclass);

conrelid in ('inh_child'::regclass, 'inh_parent'::regclass)

order by 1, 2;

conrelid | conname | contype | conkey | attname | coninhcount | conislocal | connoinherit

----------+---------+---------+--------+---------+-------------+------------+--------------

(0 rows)

(select attnamefrom pg_attributewhere attrelid= conrelidand attnum= conkey[1]),

coninhcount, conislocal, connoinherit

from pg_constraintwhere contypein ('n','p')and

conrelidin ('inh_child'::regclass,'inh_parent'::regclass);

conrelidin ('inh_child'::regclass,'inh_parent'::regclass)

order by1,2;

altertable inh_child alter a dropnot null;

select conrelid::regclass, conname, contype, conkey,

(select attnamefrom pg_attributewhere attrelid= conrelidand attnum= conkey[1]),

coninhcount, conislocal, connoinherit

from pg_constraintwhere contypein ('n','p')and

conrelidin ('inh_child'::regclass,'inh_parent'::regclass);

conrelidin ('inh_child'::regclass,'inh_parent'::regclass)

order by1,2;

altertable inh_parent alter a dropnot null;

select conrelid::regclass, conname, contype, conkey,

(select attnamefrom pg_attributewhere attrelid= conrelidand attnum= conkey[1]),

coninhcount, conislocal, connoinherit

from pg_constraintwhere contypein ('n','p')and

conrelidin ('inh_child'::regclass,'inh_parent'::regclass);

conrelidin ('inh_child'::regclass,'inh_parent'::regclass)

order by1,2;

droptable inh_parent, inh_child;