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
IIRC.
A
--
Andrew Sullivan
ajs@crankycanuck.ca