postgresql drop constraint foreign key code example

Example 1: postgresql drop primary key constraint

alter table public.test1 drop constraint test1_pkey

Example 2: how to disable foreign key constraint in postgresql

ALTER TABLE tbl_StudentMarks DISABLE TRIGGER ALL;