psql drop all tables in schema code example Example: force drop all tables postgres DROP SCHEMA public CASCADE; CREATE SCHEMA public;