Re: Drop Not Null

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: "yogesh" <yogesh(dot)arora(dot)daffodil(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Drop Not Null
Date: 2007-10-19 05:09:38
Message-ID: 003d01c81211$b72d9160$170211ac@LIONKING.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

alter table table_name alter column column_name drop not null;
----- Original Message -----
From: "yogesh" <yogesh(dot)arora(dot)daffodil(at)gmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Thursday, October 18, 2007 11:31 AM
Subject: [ADMIN] Drop Not Null

> Hello Frnds,
> What is the Command to drop the Not Null Constraint from a Column
> of the Table.....Please reply asap.............
>
> Regards,
> Yogesh Arora.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message yogesh 2007-10-19 05:39:39 Re: Drop Not Null
Previous Message Scott Marlowe 2007-10-19 01:18:07 Re: unable to install postgresql-8.1.3-1.zip for winxp