Heroku postgresql database name

I had a hard time to reset my database on Heroku. I post this, because I think it's the most straightforward solution. To find out the database name cd to your application folder and type:

heroku pg:info

Output will be something like

=== HEROKU_POSTGRESQL_BRONZE_URL
#other stuff

To reset the database type:

heroku pg:reset HEROKU_POSTGRESQL_BRONZE_URL

you have to confirm with your application name.


hope everyone confuses with placeholder and constant.

Assume having a db with name d6u5qhrlnbdfmp. then it is NOT necessary to type

heroku pg:reset d6u5qhrlnbdfmp

Instead we can plainly type

heroku pg:reset DATABASE_URL

the sample output

E:\git\stutzen>heroku pg:reset d6u5qhrlnbdfmp --app stutzen
 !    Unknown database: d6u5qhrlnbdfmp. Valid options are: DATABASE_URL, HEROKU_
POSTGRESQL_CYAN_URL

E:\git\stutzen>heroku pg:reset DATABASE_URL --app stutzen

 !    WARNING: Destructive Action
 !    This command will affect the app: stutzen
 !    To proceed, type "stutzen" or re-run this command with --confirm stutzen


> stutzen
Resetting HEROKU_POSTGRESQL_CYAN_URL (DATABASE_URL)... done

URL consists of the following parts:

scheme://username:password@host:port/database

So, in your case DB name is d14grmkt.