change null to not null in postgres code example

Example 1: postgresql change column to not null

-- To change a column to NOT NULL:
ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;

Example 2: postgres set null

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