heroku config -s |grep DATABASE_URL code example

Example: how to find my postgres hostname heorku

heroku pg:credentials:url