> can anyone please help?
> i have a to drop a check contstraint from a column. eg
>
> tradein_clients=# \d t_a
> Table "t_a"
> Column | Type | Modifiers
> ------------+---------+-----------
> company_id | integer |
> exp | text |
> imp | text |
> Check constraints: "$1" (length(imp) > 1)
> "aaaaaq" (length(imp) > 1)
>
> Can i remove to contraints thru ALTER TABLE or similar commands.
> I have read the docs for ALTER TABLE but the command described is
> not working for me.
This should work, so long as you're using postgres 7.2+
ALTER TABLE "t_a" DROP CONSTRAINT "aaaaaq" RESTRICT;
Chris
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
