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(at)gmx(dot)net