How to define certain values for column in Postgres sql?

Question

I have field Gender in my table. It should contain any one of 'M,F,O' values only. How to make it possible?

I'm using sequalize ORM in node.js for postgres, how to do it in sequalize?

You could try using an ENUM stackoverflow.com/a/22366931/742129 — nahanil
– nahanil, Commented Apr 22, 2019 at 9:49

Gordon Linoff · Accepted Answer · 2019-04-22 10:20:32Z

1

You can add a check constraint:

alter table t add constraint chk_t_gender
    check ( gender in ('M', 'F', 'O') );

Note: This check constraint allows NULL values. You can define the column as NOT NULL to disallow those.

answered Apr 22, 2019 at 10:20

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1