From: | Mark Stosberg <mark(at)summersault(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Porting MySQL's DESCRIBE and ENUM features |
Date: | 1999-11-13 16:33:15 |
Message-ID: | 382D92C3.C621932A@summersault.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I'm helping to port some somewhere from MySQL to Postgres, and am
looking for an equivalent to MySQL's DESCRIBE function. Do you know of
one for Postgres?
Specifically, one way DESCRIBE is used in this software is to get the
values from ENUM, where a MySQL column declaration might look like this:
ReceiveMail ENUM ('Yes', 'No') NOT NULL DEFAULT 'Yes',
I can get the same functionality in Postgres like this, but what can
use to get the values back of what's being checked? Thanks!
ReceiveMail CHAR(3) check(ReceiveMail in ('Yes', 'No')) NOT NULL
DEFAULT 'Yes',
-mark
<<-------------------------------------------------------------->>
personal website < Summersault Website Design
http://mark.stosberg.com/ > http://www.summersault.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 1999-11-13 17:04:41 | Re: [SQL] Porting MySQL's DESCRIBE and ENUM features |
Previous Message | Tom Lane | 1999-11-13 07:50:19 | Re: [SQL] parser :parse error |