Skip to content

Instantly share code, notes, and snippets.

@bokwoon95

bokwoon95/drop_tables.sql

Created March 24, 2020 03:57
Show Gist options
  • Save bokwoon95/a0ddc023cb543786e9b341f252d7fec8 to your computer and use it in GitHub Desktop.
Save bokwoon95/a0ddc023cb543786e9b341f252d7fec8 to your computer and use it in GitHub Desktop.
Download ZIP
drop all tables in public schema
Raw
drop_tables.sql
DO $$ DECLARE
r RECORD;
BEGIN
FOR r IN
SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname = 'public'
LOOP
EXECUTE 'DROP TABLE ' || quote_ident(r.tablename) || ' CASCADE';
END LOOP;
END $$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment