remove not null constraint 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: postgresql remove not null constraint

alter table users alter column email drop not null;

Example 3: postgresql add not null and not empty constraint

ads character varying(60) NOT NULL CHECK (ads <> '')