Re: Drop Not Null - Mailing list pgsql-admin

From yogesh
Subject Re: Drop Not Null
Date
Msg-id 1192772379.976720.148930@v23g2000prn.googlegroups.com
Whole thread Raw
In response to Re: Drop Not Null  (Alex Kloss <alexkloss@att.net>)
List pgsql-admin
On Oct 19, 4:20 am, alexkl...@att.net (Alex Kloss) wrote:
> 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
>
> Seehttp://www.postgresql.org/docs/8.2/interactive/ddl-alter.html#AEN2311
> for more information about dropping constraints.
>
> Alex Kloss
>
>  signature.asc
> 1KDownload

Thx for your Support


pgsql-admin by date:

Previous
From: "Mikko Partio"
Date:
Subject: Continuous archiving and wal generation
Next
From: yogesh
Date:
Subject: Trigger AFTER UPDATE OR INSERT