| From: | "Dave Page" <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | "Laurent ROCHE" <laurent_roche(at)yahoo(dot)com> |
| Cc: | "pgAdmin III support" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Adding columns NOT NULL |
| Date: | 2008-03-11 09:09:12 |
| Message-ID: | 937d27e10803110209y4cc38f5bkfa97f10fc42aa8e1@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Fri, Mar 7, 2008 at 10:30 AM, Laurent ROCHE <laurent_roche(at)yahoo(dot)com> wrote:
>
> So I would suggest to generate the code:
> ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL DEFAULT false;
It actually does do this already if you add the column through the
table dialogue. I've fixed the column dialogue to do it when called
directly as well (for 1.8.3).
Thanks!
--
Dave Page
EnterpriseDB UK Ltd: http://www.enterprisedb.com
PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Eschweiler | 2008-03-11 14:10:47 | Re: Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views |
| Previous Message | Dave Page | 2008-03-11 08:49:04 | Re: Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views |