Go to the database, connect through the console and perform cascading deletion of tables:
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
This command will delete the 'public' schema with all its objects, including tables, and then create a new empty 'public' schema. Note that this will delete all tables and the data in them, so be careful when using this command.