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 · 2022-11-01T20:43:30.613

842

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 Nov 01 '22 at 20:43

answered Jan 27 '11 at 05:30

mu is too short

110

The inverse is here: https://stackoverflow.com/questions/16197236/change-column-type-and-set-not-null – Christiaan Westerbeek Aug 20 '18 at 14:41
1

@ChristiaanWesterbeek mind-reader ? – Atif Shafi Dec 31 '21 at 16:37
2

Looks like the pg manual page moved here: https://www.postgresql.org/docs/current/sql-altertable.html – Kramer Nov 01 '22 at 20:08
2

@Kramer Thanks for the heads up on the link change. – mu is too short Nov 01 '22 at 20:43

1 Answers1