Pages

Tuesday, September 21, 2010

Set column nullable with PostgreSQL

Hi!

To convert a NOT NULL column to a nullable column, type the following SQL command:

ALTER TABLE schema.table ALTER COLUMN column DROP NOT NULL;

4 comments:

  1. thanks, you just saved me a lot of troubles ...

    ReplyDelete
  2. Thanks you so so much ...

    ReplyDelete
  3. Thank you so much! Very useful :)

    ReplyDelete