postgresql alter table add not null constraint code example

Example 1: postgres add not null to existing column

ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;

Example 2: postgresql add not null and not empty constraint

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