SQL

postgres remove foreign key constraint

ALTER TABLE your_tbl DROP constraint your_cnstrnt;

how to disable foreign key constraint in postgresql

ALTER TABLE tbl_StudentMarks DISABLE TRIGGER ALL;

remove foreign key constraints in postgres

set session_replication_role to replica;

postgres enable foreign keys

SET session_replication_role = DEFAULT;

postgres disable foreign keys

SET session_replication_role = replica;