delete all from table postgres code example
Example 1: force drop all tables postgres
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
Example 2: delete entries in postgresql
DELETE FROM table WHERE condition;
Example 3: delete all entries postgres
DELETE FROM tablename;
Example 4: delete entries in postgresql
DELETE FROM table
USING another_table
WHERE table.id = another_table.id;