ALTER TABLE, set null in not null column, PostgreSQL 9.1

postgresql null postgresql-9.1

ALTER TABLE person ALTER COLUMN phone DROP NOT NULL;

postgresql null postgresql-9.1

Execute the command in this format

ALTER TABLE tablename ALTER COLUMN columnname SET NOT NULL;

for setting the column to not null.

postgresql null postgresql-9.1

First, Set :ALTER TABLE person ALTER COLUMN phone DROP NOT NULL;

CodeHunter