How do you completely wipe a Postgres database? I am delivering queries through Django on the PaaS service, and i believe I can not access any command line utilities. I'd have just dropped the whole database and recreated it, however i do not have permissions for your.
I am searching for an easy command that will return the database to some completely virgin condition.
you can either cascade drop the db/schema:
drop database mydb CASCADE; drop schema myschema CASCADE;
if you don't possess the privileges to do this, you'll have to drop table by table.
EDIT: If you're able to only drop tables, this provides you with the SQL claims to operate:
select 'drop table '||schemaname||'.'||tablename||' CASCADE;' from pg_tables where schemaname = 'myschema' order by schemaname, tablename;