Skip to content

Instantly share code, notes, and snippets.

@keksipurkki

keksipurkki/nuclear.sql

Last active January 17, 2020 11:03
Show Gist options
  • Save keksipurkki/be1355c3df93fba87a0c8abb7386210d to your computer and use it in GitHub Desktop.
Save keksipurkki/be1355c3df93fba87a0c8abb7386210d to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL — Nuke the public schema
Raw
nuclear.sql
-- You sane bro?
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