Specify numeric column between 1 and 5

Question

I am trying to set up a numeric column in a postgresql table. This column may only contain a number between 1 and 5.

How should i specify this in my postgresql?

Answer 1

You want a constraint

CREATE TABLE mytable (
    constraint_col integer  CHECK (constraint_col > 0 and constraint_col < 6)
);