Horton

Re: Migrating a MySQL schema with an enum

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Keith Gray <keith@heart.com.au>
Cc: SQL <pgsql-sql@postgresql.org>
Date: 2002-03-20T23:53:55Z
Lists: pgsql-sql 
Keith Gray 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.

You can use another table, or use CHECK constraints to limit the
possible values.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026