Re: alter table

According to the documentation:

ALTER TABLE table [ * ] ADD [ COLUMN ] column type

Which means you can only set the column type of the new column. You'll have
to go back and alter that column to add a default:

ALTER TABLE table [ * ] ALTER [ COLUMN ] column { SET DEFAULT value | DROP
DEFAULT }

You'll no doubt also want to add that NOT NULL constraint:

ALTER TABLE table ADD table constraint definition

I know this only because it bit me in the ass the other day too :)

Greg

----- Original Message -----
From: "Yuri A. Kabaenkov" <sec@artofit.com>
To: <pgsql-general@postgresql.org>
Sent: Friday, November 30, 2001 10:22 AM
Subject: [GENERAL] alter table


> Hello,
>
>       I've read documentation on alter table syntax and doesn't find
>       anything about change column type or drop column.
>
>       Also when i add column by command
>       alter table test add column a integer not null default '10'
>
>       It adds column but doesn't set default value.
>
>       How can i fix it?
>
>
>
> ------------
> With respect,
> Yuri A. Kabaenkov
> hellman@artofit.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>