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 How to Implement a unique constraint in PostgreSQL when NULL conflicts with everything