Adding or Removing a Foreign Key Constraint in PostgreSQL

ALTER TABLE table_name
 ADD CONSTRAINT fk_name
 FOREIGN KEY (field_name)
 REFERENCES foreign_table_name
 ON DELETE CASCADE;

Another option is RESTRICT instead of CASCADE.

To remove/drop it:

ALTER TABLE table_name DROP CONSTRAINT "fk_name";