Answers for "alter column add unique and not null constraints in postgres"

postgres add not null to existing column

ALTER TABLE table_name ALTER COLUMN column_name SET NOT NULL;

Posted by: Guest on March-12-2020

postgresql change column to not null

-- To change a column to NOT NULL:
ALTER TABLE products ALTER COLUMN product_no SET NOT NULL;

Posted by: Guest on November-02-2020

Code answers related to "alter column add unique and not null constraints in postgres"