官方文档
http://postgres.cn/docs/13/sql-altertable.html

ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ] DROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ]

比如

ALTER TABLE tabname drop CONSTRAINT constname;