Re: [SQL] MySQLs Describe emulator!

From: clayton cottingham <drfrog(at)smartt(dot)com>
To: Boulat Khakimov <boulat(at)inet-interactif(dot)com>, psql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] MySQLs Describe emulator!
Date: 2001-03-06 16:03:41
Message-ID: 3AA50A5D.C4DBD362@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Boulat Khakimov 2001-03-06 17:00:47 Permissons on database
Previous Message Brett W. McCoy 2001-03-06 16:02:42 Re: INSERT ... RETURNING as Oracle

Browse pgsql-sql by date

  From Date Subject
Next Message clayton cottingham 2001-03-06 16:08:30 Re: platform independend db access?
Previous Message Michael Fork 2001-03-06 15:38:43 Re: [SQL] Re: MySQLs Describe emulator!