Received: from kss.net.au ([203.41.122.41]) by hub.org (8.10.1/8.10.1) with ESMTP id e6K69Zh70440 for ; Thu, 20 Jul 2000 02:09:35 -0400 (EDT) Received: from kss.net.au (coco [10.10.1.9]) by kss.net.au (8.8.7/8.8.7) with ESMTP id QAA12608 for ; Thu, 20 Jul 2000 16:11:47 +1000 Message-ID: <39769880.85E7D796@kss.net.au> Date: Thu, 20 Jul 2000 16:13:20 +1000 From: Carolyn Lu Wong X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: from not null field to nullable field? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/188 I have a field in a table that has been defined 'not null'. Is it possible to remove this constraint? I don't see this option under 'alter table'.