Answers for "how to alter column not null to null in postgresql"

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 alter column nullable

-- To change a column to nullable
ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

Posted by: Guest on February-26-2021

Code answers related to "how to alter column not null to null in postgresql"