CODEWITHSUNDEEP
sqlpostgresqlnullable
mateusmaso
mateusmaso

Reputation: 8473

How to change a PG column to NULLABLE TRUE?

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;

Upvotes: 486

Views: 278570

Answers (1)

mu is too short
mu is too short

Reputation: 434865

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.

Upvotes: 942

Related Questions