Re: Drop NOT NULL constraint !!!

--- mallah@trade-india.com wrote:
> 
> do a \d tablename
> 
> for the name of the contraint.
> say its $1
> the do
> 
> psql> alter table <tablename> drop contstraint "$1"
> RESTRICT;
> 

I alter a table with by adding a foriegn key
constraint.   ALTER TABLE sc_city  ADD CONSTRAINT cons_fkey
FOREIGN KEY state_cd REFERENCE sc_state(state_cd);

After altering the table I executed
"\d <table name>" show the following:

Triggers: RI_ConstraintTrigger_56743429
 I'm surprised that name of constraint doesn't appear
even though I explictly name it.  Is there a way to
show the name of the constraint?
 Should I do :  ALTER TABLE sc_city DROP CONSTRAINT
RI_ConstraintTrigger+5674329 RESTRICT ?

Thank you very much,
ludwig


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com