I solved a similar problem using NULLIF
function:
UPDATE table
SET col1 = NULLIF(col1, '')
NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.