How to change a PG column to NULLABLE TRUE?

nullable, postgresql, sql

Solution

From the fine manual:

ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

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

Problem

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; ```

Original source

Related problems