psql delete code example

Example 1: delete entries in postgresql

DELETE FROM table WHERE condition;

Example 2: delete all entries postgres

DELETE FROM tablename;

Example 3: delete row psql

DELETE FROM table
WHERE condition;

Example 4: postegresql delete

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

Example 5: delete entries in postgresql

DELETE FROM table
USING another_table
WHERE table.id = another_table.id;