| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2002-11-20 19:32:40 | Re: Closing inactive connections OR user connections limits |
| Previous Message | juleni | 2002-11-20 19:12:27 | List of currently connected users |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2002-11-20 19:32:40 | Re: Closing inactive connections OR user connections limits |
| Previous Message | Ren Salomo | 2002-11-20 19:09:13 | Drop NOT NULL constraint !!! |