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

[Mike Fowler <mike@xxxxxxxxxxxx>]

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general