#CASCADE DELETE POSTGRES HOW TO#

This tells Postgres to automatically delete any rows in the referenced table that are related to the row being deleted in the referencing table.Įxample: How Does the DELETE CASCADE Work in Postgres? To use a delete cascade in Postgres, specify the ' ON DELETE CASCADE' option while creating/defining a foreign key constraint. This is where Postgres’ DELETE CASCADE feature is extremely useful! Then to keep the database clean and organized, he might also want to delete all of the orders associated with that customer from the 'order_details' table. Suppose a user wants to delete a customer from the 'customer_details' table. The 'order_details' table is linked with the 'customer_details' table through a foreign key constraint. So, let’s start!įor instance, consider a database with a 'customer_details' and an 'order_details' table.

#CASCADE DELETE POSTGRES HOW TO#

This Postgres blog will present a step-by-step guide on how to use the DELETE CASCADE option in Postgres. When a DELETE CASCADE feature is enabled, deleting a record from the referenced/parent table will also delete the referencing records from the child table. In PostgreSQL, a DELETE CASCADE is a powerful feature that is useful when you have multiple tables linked with each other via foreign key constraints.

Cascade delete postgres