PostgreSQL

[ovidiub]

Is there any data type in PostgreSQL which is similar to enum('value1','value2',...) from MySQL? If you know please tell me

[ultraslacker]

Postgresql enforces referential integrity, so the use of mysql's enum isn't supported. The correct way to do this is through using a lookup table or using a CHECK constraint.

[Sxooter]

Yeah, the actual DDL looks something like this:

create table test
(
name text check in ('tom','dick','harry'),
appt timestamptz,
id serial
);