PostgreSQL 15

NULLS NOT DISTINCT for unique indexes. Treating NULL values as not distinct
for the purposes of enforcing uniqueness.

CREATE UNIQUE INDEX index_name
  ON table (column) NULLS NOT DISTINCT;