DO $$
DECLARE names CURSOR FOR
select tablename from pg_tables where schemaname='public';
BEGIN
FOR stmt IN names LOOP
EXECUTE 'truncate table '|| quote_ident(stmt.tablename);
END LOOP;
END; $$
DO $$
DECLARE names CURSOR FOR
select tablename from pg_tables where schemaname='public';
BEGIN
FOR stmt IN names LOOP
EXECUTE 'truncate table '|| quote_ident(stmt.tablename);
END LOOP;
END; $$