Answer the question
In order to leave comments, you need to log in
PostgrSQL - What is the best data type to use for statuses, object types, etc?
I often use custom types for statuses, etc.
CREATE TYPE order_status AS ENUM ('new', 'open', 'closed');
Answer the question
In order to leave comments, you need to log in
What is the difference between these types? What are the pros and cons?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question