access heroku postgres database locally code example

Example 1: connect to db heroku

heroku pg:psql -f schema.sql -a HEROKU_APP_NAME

Example 2: how to find my postgres hostname heorku

heroku pg:credentials:url