Re: Changing from NOT NULL to NULL

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Rob Mosher <mosher(at)andrews(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Changing from NOT NULL to NULL
Date: 2004-02-15 23:33:20
Message-ID: 56D58068-600F-11D8-848C-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Feb 16, 2004, at 4:57 AM, Rob Mosher wrote:

> Is there anyway I can change a field to allowing nulls without dumping
> the table, dropping it, recreating it as desired, and filling all the
> data back in?

<http://www.postgresql.org/docs/current/static/sql-altertable.html>

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message joseph speigle 2004-02-15 23:56:57 Re: Changing from NOT NULL to NULL
Previous Message Nabil Sayegh 2004-02-15 23:20:54 Re: Changing from NOT NULL to NULL