postgresql not null default examples

Example: postgres add not null to existing column

ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;