Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9D09D9FBEAA for ; Thu, 18 Oct 2007 03:05:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 69918-10 for ; Thu, 18 Oct 2007 03:05:10 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id F10B89FBE3C for ; Thu, 18 Oct 2007 03:05:11 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id l9I659kN024223 for ; Thu, 18 Oct 2007 03:05:09 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id l9I61pVn021478 for pgsql-admin@postgresql.org; Thu, 18 Oct 2007 03:01:51 -0300 (ADT) (envelope-from news) From: yogesh X-Newsgroups: pgsql.admin Subject: Drop Not Null Date: Thu, 18 Oct 2007 06:01:50 -0000 Organization: http://groups.google.com Lines: 7 Message-ID: <1192687310.749557.227290@q5g2000prf.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 SUMAN1, 1.1 SIFY Complaints-To: groups-abuse@google.com Injection-Info: q5g2000prf.googlegroups.com; posting-host=124.30.27.18; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/162 X-Sequence-Number: 27076 Hello Frnds, What is the Command to drop the Not Null Constraint from a Column of the Table.....Please reply asap............. Regards, Yogesh Arora.