how to drop all tables in postgreSQL

Hrasha

how to drop all tables in postgreSQL but I don't want to drop table using command line

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
If all of your tables are in a single schema, this approach could work (below code assumes that the name of your schema is public)
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
If you are using PostgreSQL 9.3 or greater, you may also need to restore the default grants.
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
+1
Sagar Lad5y ago
Hi Harsha,
You can use this to drop all tables :
DROP SCHEMA public CASCADE; CREATE SCHEMA public;
0