Skip site navigation (1) Skip section navigation (2)

Re: Drop Not Null

From: Alex Kloss <alexkloss(at)att(dot)net>
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-18 23:20:39
Message-ID: 4717EA47.2080701@att.net (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2007-10-19 01:18:07
Subject: Re: unable to install postgresql-8.1.3-1.zip for winxp
Previous:From: Alex KlossDate: 2007-10-18 22:22:48
Subject: Re:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group