Delete

Delete select rows

DELETE FROM my_table
WHERE id IN (1, 2, 3)
;

Cascade

If you get an error from foreign key constraints:

DELETE FROM my_table CASCADE
-- WHERE ...
;

Delete all rows

DELETE FROM my_table;

TRUNCATE my_table;

TRUNCATE my_table;
CASCADE