Re: What is the good equivalent for ENUM ?

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: What is the good equivalent for ENUM ?
Date: 2003-09-03 12:46:01
Message-ID: 3F562FE1.9350.5EF1A61@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3 Sep 2003 at 14:30, Bruno BAGUETTE wrote:

> Hello,
>
> I have to migrate a MySQL database to a PostgreSQL database without
> procedures.
>
> The problem is that this MySQL database uses ENUM, do you see what can I
> do to migrate ENUM into PostgreSQL ?

varchar with check constraints. Add constraits to allow only certain values of
varchar string.

Check http://archives.postgresql.org/pgsql-sql/2002-03/msg00273.php

Bye
Shridhar

--
All new: Parts not interchangeable with previous model.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Amin Schoeib 2003-09-03 13:02:34 Trunc in Postgres
Previous Message Bruno BAGUETTE 2003-09-03 12:30:22 What is the good equivalent for ENUM ?