Re: [SQL] MySQLs Describe emulator!

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