Re: Adding a default value to a column after it exists - Mailing list pgsql-general

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