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

PHOTO EMBED

Mon Aug 07 2023 01:44:27 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

-- Schema: public

-- DROP SCHEMA public;

CREATE SCHEMA public
  AUTHORIZATION postgres;

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