Re: [SQL] MySQLs Describe emulator! - Mailing list pgsql-general

From clayton cottingham
Subject Re: [SQL] MySQLs Describe emulator!
Date
Msg-id 3AA50A5D.C4DBD362@smartt.com
Whole thread Raw
In response to MySQLs Describe emulator!  (Boulat Khakimov <boulat@inet-interactif.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Mathijs Brands
Date:
Subject: Re: [SQL] Undefined symbol
Next
From: Aristide Aragon
Date:
Subject: varchat ->text