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
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 |
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! |