Heroku postgresql database name

Question

This is the command I have to find the name of a heroku database:

$ heroku config | grep POSTGRESQL

I get a result similar to:

HEROKU_POSTGRESQL_NAVY_URL: postgres://wxjwilh:[email protected]:52/d14grmkt

which part of this output is the database name I can use with the command:

$ heroku pg:reset <DATABASE>

I tried using the whole url but got an invalid argument error.

question from:https://stackoverflow.com/questions/14141803/heroku-postgresql-database-name

Answer 1

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:gitstutzen>heroku pg:reset d6u5qhrlnbdfmp --app stutzen
 !    Unknown database: d6u5qhrlnbdfmp. Valid options are: DATABASE_URL, HEROKU_
POSTGRESQL_CYAN_URL

E:gitstutzen>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