Hi Dave,
On 13/04/11 17:21, 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'".
>
Sure is something like that:
ALTER TABLE tablename ALTER COLUMN columnname SET DEFAULT expression;
For full documentation see:
http://www.postgresql.org/docs/9.0/static/sql-altertable.html
> Thanks for any help.
>
Regards,
--
Mike Fowler
Registered Linux user: 379787