Received: from www.optimumdigital.com (unknown [64.245.24.5]) by postgresql.org (Postfix) with ESMTP id 38CE84758DD for ; Thu, 21 Mar 2002 09:48:45 -0500 (EST) Received: from xaymaca.com ([63.115.42.161]) by www.optimumdigital.com (8.11.6/8.11.6) with ESMTP id g2LEhNG26438; Thu, 21 Mar 2002 09:43:23 -0500 Message-ID: <3C99F0EA.2050206@xaymaca.com> Date: Thu, 21 Mar 2002 09:40:42 -0500 From: Vincent Stoessel User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9+) Gecko/20020318 X-Accept-Language: en-us, en MIME-Version: 1.0 To: =?ISO-8859-1?Q?Mart=EDn_Marqu=E9s?= Cc: SQL Subject: Re: Migrating a MySQL schema with an enum References: <3C991E29.C90559F4@heart.com.au> <20020321113145.E84DBFA1D@bugs.unl.edu.ar> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Archive-Number: 200203/278 X-Sequence-Number: 7157 Martín Marqués wrote: > On Mié 20 Mar 2002 20:41, you wrote: > >>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. > > > I had to migrate a DB from MySQL to PostgreSQL that had some enum as field > data type (I can't believe that something like that exists) another shot at the mysql db. Please don't forget that PG also has non standard data types available. Vinny