how to delete all data from all tables in postgresql code example Example: force drop all tables postgres DROP SCHEMA public CASCADE; CREATE SCHEMA public;