Search code examples
postgresqlherokuheroku-postgres

How to see what is in your Heroku-Postgress DB

I recently uploaded a WebApplication to Heroku. I developed it using sqlite; however, I then changed it to Heroku-Postgres. Nonetheless, I am not able to view in any way the data that is in my database.

There are no problems with the code and the WebApplication works perfectly however it would be very useful to be able to tap into the data.

Solution

  • Download the Heroku CLI and get access to the postgres admin console.

    heroku pg:psql -a appName

    Use this command in terminal, This will connect you to pgadmin console.