--- [EMAIL PROTECTED] wrote:
>
> do a \d tablename
>
> for the name of the contraint.
> say its $1
> the do
>
> psql> alter table 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_c
do a \d tablename
for the name of the contraint.
say its $1
the do
psql> alter table 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
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 searc
