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

Re: [SQL] Drop NOT NULL constraint !!!

From: <mallah(at)trade-india(dot)com>
To: <rene(at)ibiz(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Drop NOT NULL constraint !!!
Date: 2002-11-20 19:17:58
Message-ID: 50448.203.145.129.4.1037819878.squirrel@mail.trade-india.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-sql
do a \d tablename

for the name of the contraint.
say its $1
the do

psql> alter table <tablename> drop contstraint "$1" RESTRICT;

> Does anybody could tell me how to drop a constraint on a column where no name was provided to
> the constraint? How does Pg name constraints?
>
> Thanks
> --
> Renê Salomão
> Ibiz Tecnologia -- www.ibiz.com.br
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you
> searched our list archives?
>
> http://archives.postgresql.org



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/



In response to

Responses

pgsql-sql by date

Next:From: scott.marloweDate: 2002-11-20 19:32:40
Subject: Re: Closing inactive connections OR user connections limits
Previous:From: Ren SalomoDate: 2002-11-20 19:09:13
Subject: Drop NOT NULL constraint !!!

pgsql-general by date

Next:From: scott.marloweDate: 2002-11-20 19:32:40
Subject: Re: Closing inactive connections OR user connections limits
Previous:From: juleniDate: 2002-11-20 19:12:27
Subject: List of currently connected users

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