Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f2CJuQx54701 for ; Mon, 12 Mar 2001 14:56:26 -0500 (EST) (envelope-from pgsql-general-owner@postgresql.org) Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f26G1nx23326 for ; Tue, 6 Mar 2001 11:01:50 -0500 (EST) (envelope-from drfrog@smartt.com) Received: (qmail 29604 invoked from network); 6 Mar 2001 16:01:42 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (drfrog@10.1.4.1) by marketingchallenge.com with SMTP; 6 Mar 2001 16:01:42 -0000 Message-ID: <3AA50A5D.C4DBD362@smartt.com> Date: Tue, 06 Mar 2001 08:03:41 -0800 From: clayton cottingham X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Boulat Khakimov , psql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [SQL] MySQLs Describe emulator! References: <3AA44897.121D60F0@inet-interactif.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/514 X-Sequence-Number: 6002 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