Skip to content

Instantly share code, notes, and snippets.

@sviatoslav-lebediev

sviatoslav-lebediev/gist:3f081998b48f3017f8f85e86a86b396c

Forked from balazs-endresz/gist:f9b27514046506a7db75
Created February 22, 2018 17:11
Show Gist options
  • Save sviatoslav-lebediev/3f081998b48f3017f8f85e86a86b396c to your computer and use it in GitHub Desktop.
Save sviatoslav-lebediev/3f081998b48f3017f8f85e86a86b396c to your computer and use it in GitHub Desktop.
Download ZIP
Drop all tables and sequences in postgres
Raw
gistfile1.sql
# tables for owned by 'tableowner'
select 'drop table if exists "' || tablename || '" cascade;' from pg_tables where tableowner='tableowner';
# all sequences
select 'drop sequence if exists "' || relname || '" cascade;' from pg_class where relkind = 'S';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment