heya:
why not try:
drfrog=# \d messages
Table "messages"
Attribute | Type | Modifier
-------------------+---------+----------
id | integer | not null
msgid | text |
boxid | integer |
accountid | integer |
date | text |
sentto | text |
sentfrom | text |
subject | text |
contenttype | text |
contentxferencode | text |
mimeversion | text |
precedence | text |
approvedby | text |
inreplyto | text |
replyto | text |
listsub | text |
listunsub | text |
status | text |
xorigip | text |
cc | text |
bcc | text |
sender | text |
returnpath | text |
priority | text |
xmailer | text |
xuidl | text |
xsender | text |
localdate | text |
newmsg | text |
replyf | integer |
friendly | text |
rreceiptto | text |
score | integer |
ref | text |
serverstat | integer |
Index: messages_pkey