Tutorial 12- UNIQUE AND NOT NULL CONSTRAINT

Learn about UNIQUE AND NOT NULL CONSTRAINT in PostgreSQL.

[xzqtmic]

UNIQUE (product_no, name) tells that a pair <product_no, name> should be unique, not each column separately.

Try to set unique constraint for separate columns.

[Dilshad]

How you (Update) decrease column already created and contains white space?

[anthonythudium]

Why is capitalization necessary? PSQL 9.6 doesn't require it.