How to connect to Heroku Postgres?

Question

PostgreSQL

Good day. Created a database on Heroku. Is there some way to connect to it with visualization instead of via console?
As a novice programmer, it’s a little difficult for me to do everything through the console, I would like to see all these rows and columns.
Thank you.

Answer 1

1. Here, for example, sosedoff.github.io/pgweb
2. You will need the following data to connect to the database in Heroku: Host, Database, Port, User, Password
3. They can be found on Heroku.com in Datastores-> Base Instance ->Settings->View credentials.