Skip to content

Instantly share code, notes, and snippets.

@mjhea0

mjhea0/drop_postgres_schema.txt

Created October 20, 2014 14:52
Show Gist options
  • Save mjhea0/8fc976cc989b7c0c694e to your computer and use it in GitHub Desktop.
Save mjhea0/8fc976cc989b7c0c694e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
drop_postgres_schema.txt
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO <USERNAME>;
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