alter table set column nullable postgresql code example Example: allow null in psql ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;