How to change a PG column to NULLABLE TRUE?

Question

How can I accomplish this using Postgres? I've tried the code below but it doesn't work:

ALTER TABLE mytable ALTER COLUMN mycolumn BIGINT NULL;

mu is too short · Accepted Answer · 2012-05-21T05:32:39.127

688

ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

There's no need to specify the type when you're just changing the nullability.

edited May 21 '12 at 05:32

answered Jan 27 '11 at 05:30

mu is too short

84

The inverse is here: https://stackoverflow.com/questions/16197236/change-column-type-and-set-not-null – Christiaan Westerbeek Aug 20 '18 at 14:41
@ChristiaanWesterbeek mind-reader ? – Atif Shafi Dec 31 '21 at 16:37

1 Answers1