alter table ?

From: Kevin Heflin <kheflin(at)shreve(dot)net>
To: "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org>
Subject: alter table ?
Date: 1998-11-12 21:32:31
Message-ID: Pine.LNX.4.02.9811121529100.3023-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message 송기원 1998-11-13 00:37:40 How to restart postgresql??
Previous Message elliotj 1998-11-12 19:40:02 Problem installing on AIX 4.2