Answers for "alter column not null 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 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 "alter column not null postgres#"