In article <20110413163120.gu24...@shinkuro.com>, Andrew Sullivan <a...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
