Postgres Pro
Downloads
Home   >   mailing lists

alter table ? - Mailing list pgsql-general

From Kevin Heflin
Subject alter table ?
Date
Msg-id Pine.LNX.4.02.9811121529100.3023-100000@mercury.shreve.net
Whole thread Raw
In response to Re: [GENERAL] select LIKE  (David Hartwig <daybee@bellatlantic.net>)
Responses Re: [GENERAL] alter table ?  (Postgres DBA <postgres@nest.bistbn.com>)
List pgsql-general
Tree view 
I went to alter a table, to add a column like so:

alter table passwd add column spamblock bool DEFAULT 'TRUE'

this added the new column of type bool but did not make the default true.

Any suggestions?

Kevin


--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

pgsql-general by date:

Previous
From: elliotj@coxnews.com
Date:
Subject: Problem installing on AIX 4.2
Next
From: "송기원"
Date:
Subject: How to restart postgresql??