RE: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions - Mailing list pgsql-general

> I don't care how but I need to emulate ENUM type, just to convert
> MySQL dumps to PostgreSQL. E.g. ENUM values
> stored in MySQL dump should be restorable in Postgres without any
> conversion.

In MySQL, ENUM is like this:

create table blah (
    sex ENUM ('M', 'F')
);

This can be emulated in Postgres like this:

create table blah (
    sex CHAR(1) CHECK (sex IN ('M', 'F'))
);

The _real_ trick is implementing MySQL sets in Postgres...

Chris