All statements works in PostgreSQL 9.1+. For more PostgreSQL notes, check out PostgreSQL Guide

Deleting matching rows.

DELETE
FROM task
WHERE status = 'DONE';

DELETE
FROM film
WHERE producer_id IN (SELECT id
                      FROM producer
                      WHERE name = 'foo');

TRUNCATE empties a table and the related tables. Really useful for development and testing.

TRUNCATE some_table CASCADE;

Sources

• PostgreSQL - DELETE
• Postgres Guide
• PostgreSQL documentation