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

"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> 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 ... ALTER COLUMN ... SET DEFAULT ...

            regards, tom lane