add not null constraint postgres sql code example

Example 1: postgresql add not null constraint

alter table users alter column email set not null;

Example 2: postgresql add not null and not empty constraint

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