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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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