Skip to content

Instantly share code, notes, and snippets.

@kasymovga

kasymovga/how to clear postgresql database

Created February 8, 2017 10:40
Show Gist options
  • Save kasymovga/5986402c10482af0c0eb6318945de4ed to your computer and use it in GitHub Desktop.
Save kasymovga/5986402c10482af0c0eb6318945de4ed to your computer and use it in GitHub Desktop.
Download ZIP
how to clear postgresql database
Raw
how to clear postgresql database
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