wildzyzop/pgsql-drop-all-tables.md

Created November 25, 2019 17:43

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wildzyzop/982a00a427a544cdfd3af4ddc44c2a92.js"></script>
Save wildzyzop/982a00a427a544cdfd3af4ddc44c2a92 to your computer and use it in GitHub Desktop.

Download ZIP

Drop all the tables in a PostgreSQL database

Raw

pgsql-drop-all-tables.md

Drop all the tables in a 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';

https://stackoverflow.com/questions/3327312/how-can-i-drop-all-the-tables-in-a-postgresql-database

wildzyzop/pgsql-drop-all-tables.md

Select an option

No results found

Select an option

No results found