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

Sun, 4 Jan 1998 21:14:37 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
new \d information