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