CODE EXAMPLE FOR SQL

set value to null postgres

UPDATE table1 
SET column_a = NULL
WHERE column_b = 'XXX';