Skip to content

Instantly share code, notes, and snippets.

@knil-sama

knil-sama/drop_all_tables_sql

Created November 26, 2018 16:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save knil-sama/9dc3c767393a41950b9e567e7d12f6bf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save knil-sama/9dc3c767393a41950b9e567e7d12f6bf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
drop_all_tables_sql
select 'drop table if exists "' || tablename || '" cascade;'
from pg_tables
where schemaname = 'public';
?column?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment