Drop All Tables

drop_all_tables.sql

DO LANGUAGE plpgsql $$
DECLARE
  t record;
  tables text[];
BEGIN
  FOR t IN SELECT schemaname, tablename FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') LOOP
    tables := array_append(tables, quote_ident(t.schemaname) || '.' || quote_ident(t.tablename));
  END LOOP;

  IF array_length(tables, 1) > 0 THEN
    EXECUTE 'DROP TABLE ' || array_to_string(tables, ', ') || ' CASCADE';
  END IF;
END$$;