As we previously mentioned, now is the time to connect from our local location to our Heroku service through pgAdmin. Let's see how to do it:
- On our local pgAdmin in the browser, we will right-click on Servers and then click on Create | Server...:
- On the Connection tab, we will name it Heroku Postgres:
- Following that, we will add our credentials previously obtained on Heroku on the Connection tab:
- Once the credentials have been validated, we will expand the Heroku Postgres instance and over a public schema, we will right-click and select Query Tool from the contextual menu:
- On the new Query Editor tab, we can refer to Chapter 2, Setting Up a PostgreSQL RDS...