CODE EXAMPLE FOR SQL

create unique constraint postgres

//psql's inline help:
$ h ALTER TABLE

ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE (columns);