Re: Migrating a MySQL schema with an enum

Vincent Stoessel <vincent@xaymaca.com>

From: Vincent Stoessel <vincent@xaymaca.com>
To: Martín Marqués <martin@bugs.unl.edu.ar>
Cc: SQL <pgsql-sql@postgresql.org>
Date: 2002-03-21T14:40:42Z
Lists: pgsql-sql
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)

<snip>

another shot at the mysql db.
Please don't forget that PG also has non standard data types
available.


Vinny