Porting MySQL's DESCRIBE and ENUM features

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/

Responses

Browse pgsql-sql by date

  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