TRUNCATE TABLE name1, name2, ... CASCADE
TRUNCATE quickly removes all rows from a set of tables. It has the same effect as an unqualified DELETE on each table, but since it does not actually scan the tables it is faster. This is most useful on large tables.
If you have a lot of tables you might want to query for the list of tables and construct the truncate query dynamically, but for a small number of tables you could just type the names in by hand.
See this post for information on selecting all tables and running a query dynamically. The example given is for grantall
but the idea is the same.