sudo -u postgres psql \c table_name #DISABLE FOREIGN FIELDS SET session_replication_role = replica; # DELETE THE TABLES DO $$DECLARE r RECORD; BEGIN FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP EXECUTE 'DROP TABLE IF EXISTS "' || r.tablename || '" CASCADE'; END LOOP; END$$; #ENABLE FOREIGN KEY CONTRAINTS SET session_replication_role = DEFAULT; TRUNCATE [ TABLE ] [ ONLY ] name [ * ] [, ... ] [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]