"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)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