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; 

Answer 1

Try this code:

ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;

Note: Don't specify the type when you're just changing the nullability.

For more information, you can refer to this link:

https://www.postgresql.org/docs/current/sql-altertable.html