To get rid of the NOT NULL costraint run: ALTER TABLE <your-table> ALTER COLUMN <your-column> DROP NOT NULL;