Skip to content

Instantly share code, notes, and snippets.

@anilktechie

anilktechie/postgresql-drop-all-tables.sql

Forked from kagundajm/postgresql-drop-all-tables.sql
Created December 31, 2021 08:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save anilktechie/6458db4a72841a20310afb09a2201fc5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save anilktechie/6458db4a72841a20310afb09a2201fc5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgresql-drop-all-tables.sql
DO $$
DECLARE
r RECORD;
BEGIN
FOR r IN
(
SELECT table_name
FROM information_schema.tables
WHERE table_schema=current_schema()
)
LOOP
EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.table_name) || ' CASCADE';
END LOOP;
END $$ ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment