Question

How to add a UNIQUE constraint in PostgreSQL

Answer 1

ALTER TABLE your_table
ADD CONSTRAINT constraint_name UNIQUE (column_name);


-- Example: 

ALTER TABLE organization_members
ADD CONSTRAINT constraint_name UNIQUE (organization_id, user_id)

 

70+ SQL courses for beginners and professionals