Does PostgreSQL have an enum data type?

[aardvark92]

I'm moving to PostgreSQL after using MySQL for a few years. One of MySQL's features is an enum data type, which is used to select from a list.

For example, I might declare a field

rating ENUM("good","fair","poor")

to limit it to those three values.

I haven't found an exact equivalent in PostgreSQL. Is there one, or do I need to use the CONSTRAINT clause to limit a field's allowed values?

 

[rycamor]

There is no datatype ENUM in PostgreSQL, but it is quite easy to handle this with a CHECK constraint --

http://www.postgresql.org/docs/8.0/interactive/ddl-constraints.html

Often it is a better design choice to use foreign key constraints with validation tables to accomplish this sort of constraint, because it allows your database model to evolve more flexibly.

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html