Re: [GENERAL] Adding a default value to a column after it exists

[Mike Fowler]

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general