delete from where postgres code example

Example 1: delete entries in postgresql

DELETE FROM table WHERE condition;

Example 2: postegresql delete

DELETE FROM films
  WHERE producer_id IN (SELECT id FROM producers WHERE name = 'foo');