MySQL → PostgreSQL

Convert MySQL ENUM to PostgreSQL enum types

Both engines support enums, but PostgreSQL enums are standalone named types rather than inline column definitions, so each MySQL ENUM column gets its own CREATE TYPE.

What to know

• A PostgreSQL enum type is created per column with identical labels
• Values migrate unchanged; invalid empty-string values ('') become NULL
• Adding labels later: ALTER TYPE … ADD VALUE
• Alternative mapping: text + CHECK constraint, if you prefer flexibility over strictness

Before / after

CREATE TABLE users (
  status ENUM('active','banned','pending') DEFAULT 'pending'
);

CREATE TYPE users_status AS ENUM ('active','banned','pending');
CREATE TABLE users (
  status users_status DEFAULT 'pending'
);

See the full type mapping table or all guides.