Received: from gateway.heart.com.au (unknown [203.12.235.237]) by postgresql.org (Postfix) with ESMTP id 3585E475C65 for ; Wed, 20 Mar 2002 18:40:43 -0500 (EST) Received: from tardis.heart.com.au (IDENT:root@tardis.heart.com.au [192.168.0.42]) by gateway.heart.com.au (8.11.2/8.11.2) with ESMTP id g2LA13s31750 for ; Thu, 21 Mar 2002 21:01:03 +1100 Received: from heart.com.au ([192.168.0.53]) by tardis.heart.com.au (8.9.3/8.8.7) with ESMTP id KAA27865 for ; Thu, 21 Mar 2002 10:40:32 +1100 Message-ID: <3C991E29.C90559F4@heart.com.au> Date: Thu, 21 Mar 2002 10:41:30 +1100 From: Keith Gray X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: SQL Subject: Migrating a MySQL schema with an enum Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/267 X-Sequence-Number: 7146 SQL gurus, Migrating a MySQL schema with an enum to PostgreSQL, is there an equivalent type or do I have to declare another table for "enum" values. -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au