Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 0F141475DEE for ; Tue, 4 Jun 2002 19:06:40 -0400 (EDT) Received: from dollar.betterhealthfoundation.net (user-112ugh2.biz.mindspring.com [66.47.66.34]) by postgresql.org (Postfix) with ESMTP id 2D7814759FC for ; Tue, 4 Jun 2002 19:04:01 -0400 (EDT) Received: from mark ([192.168.1.11]) by dollar.betterhealthfoundation.net with Microsoft SMTPSVC(5.0.2195.4905); Tue, 4 Jun 2002 16:04:03 -0700 From: "Tom Haddon" To: Subject: alter column - NOT NULL Date: Tue, 4 Jun 2002 16:04:03 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 Importance: Normal X-OriginalArrivalTime: 04 Jun 2002 23:04:03.0657 (UTC) FILETIME=[1EE27390:01C20C1C] X-Archive-Number: 200206/34 X-Sequence-Number: 7999 Hi, Kind of a basic one here. I am trying to change a column so that it has the property of NOT NULL. How do I do this? I have been able to add the column to a table, and to set its default value with the ALTER command, but this one escapes me. If you could provide an example that would be very useful. Thanks, Tom _______________________________ Tom Haddon IT Director The Better Health Foundation 414 Thirteenth Street, Suite 450 Oakland, CA 94612 (510) 444-5096 www.betterhealthfoundation.org ________________________________