Re: Migrating a MySQL schema with an enum

From: Vincent Stoessel <vincent(at)xaymaca(dot)com>
To: Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Migrating a MySQL schema with an enum
Date: 2002-03-21 14:40:42
Message-ID: 3C99F0EA.2050206@xaymaca.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Ross J. Reedstrom 2002-03-21 16:02:28 Re: Migrating a MySQL schema with an enum
Previous Message Christopher Kings-Lynne 2002-03-21 14:29:39 Re: [OOT] timestamp / time ('now') in postgresql 7.2?