What is the canonical way to drop a database in Render

[tosbourn]

I have a database that I am testing some imports from a Heroku project. I will want to do this several times as we play about with things.

What is the best way to drop the database to start over?

Any research I’ve done points to either deleting the database and creating a brand new one (seems overkill, especially if I want to keep a standard naming convention) or doing this using postgres and recreating the public schema, which seems better but also potentially dangerous if permissions aren’t identical to how Render creates things.

[John_B]

That’s the easiest option - to be sure it’s vanilla.

When we provision a Postgres instance, we create the database for you, which is what you see in the service’s dashboard.

I did a quick test and was able to drop the entire public schema and then recreate it through so that remains an option.

drop schema public cascade;
create schema public;