how to use check constraint in postgresql for string

Question

i am new to postgres

how to create table with check constraint for column name say polluted which only have to accept 'yes' or 'no' values on insert.

for other values it should promote error message

My table name is vehicles

Why don't you use a boolean type? That would be a much better choice for a yes/no flag — user330315
– user330315, Commented Jul 12, 2018 at 7:04

user330315 · Accepted Answer · 2018-07-12 07:07:01Z

20

Use an in condition.

create table vehicles
(
  id integer primary key, 
  polluted text not null check (polluted in ('yes', 'no'))
);

answered Jul 12, 2018 at 7:07

user330315

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

1 Comment

your query working fine and also how to write constraint error message if other value is inserted