Re: Drop Not Null - Mailing list pgsql-admin

From Alex Kloss
Subject Re: Drop Not Null
Date
Msg-id 4717EA47.2080701@att.net
Whole thread Raw
In response to Drop Not Null  (yogesh <yogesh.arora.daffodil@gmail.com>)
Responses Re: Drop Not Null  (yogesh <yogesh.arora.daffodil@gmail.com>)
List pgsql-admin
yogesh wrote:
> 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
>
>
ALTER TABLE table ALTER COLUMN column DROP NOT NULL

See http://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
for more information about dropping constraints.

Alex Kloss


Attachment

pgsql-admin by date:

Previous
From: Alex Kloss
Date:
Subject: Re:
Next
From: "Scott Marlowe"
Date:
Subject: Re: unable to install postgresql-8.1.3-1.zip for winxp