drop all tables postgresql psql code example
Example 1: force drop all tables postgres
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
Example 2: how to remove tables from postgresql
DROP TABLE IF EXISTS tablename;
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
DROP TABLE IF EXISTS tablename;