drop a check - Mailing list pgsql-sql

From ivan marchesini
Subject drop a check
Date
Msg-id 1163435526.6395.27.camel@geoivan
Whole thread Raw
Responses Re: drop a check
Re: drop a check
List pgsql-sql
Dear all...
I have created a check constraint without giving it a name..
now I have a check named "$25" in my table that I need to drop or
modify!!!
How can I do???
with names is simple

alter table tablename drop constraint constraintname;

but without name??   :-)

many thanks...

Ivan




-- 
Ivan Marchesini
Department of Civil and Environmental Engineering
University of Perugia
Via G. Duranti 93/a 
06125
Perugia (Italy)
e-mail: marchesini@unipg.it       ivan.marchesini@gmail.com
tel: +39(0)755853760
fax: +39(0)755853756
jabber: geoivan73@jabber.org





pgsql-sql by date:

Previous
From: "Rodrigo Sakai"
Date:
Subject: RES: Inserting data in composite types!
Next
From: "Rodrigo Sakai"
Date:
Subject: Another question about composite types