Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Adding a default value to a column after it exists
Date
Msg-id 6519.1302712167@sss.pgh.pa.us
Whole thread Raw
In response to Adding a default value to a column after it exists  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view 
"Gauthier, Dave" <dave.gauthier@intel.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

pgsql-general by date:

Previous
From: Mike Fowler
Date:
Subject: Re: Adding a default value to a column after it exists
Next
From: Andrew Sullivan
Date:
Subject: Re: Adding a default value to a column after it exists