postgres not null constraint with condition code example Example: postgresql add not null and not empty constraint ads character varying(60) NOT NULL CHECK (ads <> '')