postgres delete all rows from all tables code example
Example 1: force drop all tables postgres
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
Example 2: delete all entries postgres
DELETE FROM tablename;
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
DELETE FROM tablename;