how do i delete a person usign their first_name in postgresql shell code example

Example: postegresql delete

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