I have added NOT NULL and DEFAULT indications to \d:
test=> \d testz
Table = testz
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| x | int4 not null default '4' | 4 |
+----------------------------------+----------------------------------+-------+
Some people have asked for this on the questions list.
--
Bruce Momjian
maillist@candle.pha.pa.us