Skip to content

Instantly share code, notes, and snippets.

@DevanR

DevanR/drop_all_db.sql

Created December 7, 2017 23:10
Show Gist options
  • Save DevanR/c5c319039b7781c623258e156b3dfc22 to your computer and use it in GitHub Desktop.
Save DevanR/c5c319039b7781c623258e156b3dfc22 to your computer and use it in GitHub Desktop.
Download ZIP
Drop all Postgres tables
Raw
drop_all_db.sql
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public IS 'standard public schema';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment