How can I drop all the tables in a PostgreSQL database? - Stack Overflow

PHOTO EMBED

Wed Jul 05 2023 18:40:08 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

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';
content_copyCOPY

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