Re: Migrating a MySQL schema with an enum

Keith Gray writes:

> 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.

Generally, you'd use a text field with a check constraint.  For example:

CREATE TABLE car (
 ...
 color text check (color in ('blue', 'green', 'yellow')),
 ...
);

-- 
Peter Eisentraut   peter_e@gmx.net