I have tried https://devcenter.heroku.com/articles/heroku-postgresql#local-setup but
keeps returning "not found" heroku pg:psql app::databaseName returns The local psql command could not be located. I have add the path to the PostgreSQL bin file into my PATH but the error still appears.
heroku pg:psql push <database name> HEROKU_POSTGRESQL_BLUE_URL --app <app name>
but we ended up with Fatal password authentication failed for User.
We changed the pg_hba.conf file for the host method to be trust
# Type Database User Address Method # IPv4 local connections: host all all <address> trust
But now the error returned is that the user doesn't exist.