How to check when inserting into a table for example if psql?

Question

PostgreSQL

How can I check when inserting into a table, for example, if
I want to insert only words into the work column - 'registrar' , 'coordinator', 'user'
how can I do (

create table person (
id serial,
name varhcar(30) not null check( name='registrator' and 'coordinator' or 'user' )

Answer 1

CREATE TABLE qna
(
  name VARCHAR(30) NOT NULL CHECK (name IN ('registrator', 'coordinator', 'user'))
);

sqlfiddle.com/#!15/90730