Received: from summersault.com (nollie.summersault.com [199.120.185.41]) by hub.org (8.9.3/8.9.3) with SMTP id LAA75514 for ; Sat, 13 Nov 1999 11:33:09 -0500 (EST) (envelope-from mark@summersault.com) Received: (qmail 4674 invoked from network); 13 Nov 1999 16:33:07 -0000 Received: from mark.summersault.com (HELO summersault.com) (199.120.185.113) by nollie.summersault.com with SMTP; 13 Nov 1999 16:33:07 -0000 Message-ID: <382D92C3.C621932A@summersault.com> Date: Sat, 13 Nov 1999 11:33:15 -0500 From: Mark Stosberg Reply-To: mark@summersault.com Organization: Summersault X-Mailer: Mozilla 4.7 (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Porting MySQL's DESCRIBE and ENUM features Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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/