Re: Adding a default value to a column after it exists

In article <20110413163120.GU24471@shinkuro.com>,
Andrew Sullivan <ajs@crankycanuck.ca> writes:

> On Wed, Apr 13, 2011 at 09:21:20AM -0700, Gauthier, Dave wrote:
>> Is there a way to add a default value definition to an existing column?  Something like an "alter table... alter
column...default 'foo'". 

> ALTER TABLE table ALTER [ COLUMN ] column SET DEFAULT expression

> (see http://www.postgresql.org/docs/9.0/interactive/sql-altertable.html)

> Note that this doesn't actually update the fields that are NULL in the
> column already.  For that, once you had the default in place, you
> could do

> UPDATE table SET column = DEFAULT WHERE column IS NULL

And you probably want to do
  ALTER TABLE table ALTER [ COLUMN ] column SET NOT NULL
after that.