how to connect to postgres database heroku code example

Example 1: connect to db heroku

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

Example 2: how to push database to heroku

heroku run rails db:migrate

Example 3: how to find my postgres hostname heorku

heroku pg:credentials:url