PostgreSQL Check or trigger

Question

I have a table called products and one of columns is called names.

When I insert a new product, I want to check if name of the new product already exists in names and then show an error message.

Anyone have any ideas?

Hugo · Accepted Answer · 2020-03-18 16:43:29Z

1

You should add a unique constraint on your names column:

ALTER TABLE products ADD UNIQUE (names);

answered Mar 18, 2020 at 16:43

Hugo

8541 gold badge10 silver badges30 bronze badges

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

1 Answer 1