How do you wipe a Postgresql database?

Question

I'm sending queries through Django on a PaaS service, and I think I can't access any command line utilities. I would have just dropped the entire database and recreated it, but I don't have permissions for that.

I'm looking for a simple command that would return the database to a completely virgin state.

This question is similar to: How can I drop all the tables in a PostgreSQL database?. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — Wes Lord
– Wes Lord, Commented Aug 1, 2024 at 17:03

Community · Accepted Answer · 2014-08-12 20:26:06Z

12

you could cascade drop the schema and then drop the db:

drop schema myschema CASCADE;
drop database mydb;

if you do not have the rights to do so, you will have to drop table by table.

EDIT: If you can only drop tables, this will give you the SQL statements to run:

select 'drop table '||schemaname||'.'||tablename||' CASCADE;' 
from pg_tables where schemaname = 'myschema' order by schemaname, tablename;

edited Aug 12, 2014 at 20:26

CommunityBot

11 silver badge

answered Nov 1, 2011 at 17:03

Martin Samson

4,09024 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do you wipe a Postgresql database?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related