To implement a unique constraint in PostgreSQL when NULL conflicts with everything, you can use the following method: Use the COALESCE function to replace any NULL values in the new column with a unique value, … Continue reading PostgreSQL Unique Contraint: Implementing It When NULL Conflicts with Everything