> 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