SQL

how to create enum in postgreSQL

CREATE TYPE enum_name AS ENUM('value1', 'value2', 'value3');

create enum postgres

CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');