How to manage remote Heroku Postgres DB

• On OS X download and install PG commander from https://eggerapps.at/pgcommander/ . On other platforms you can use http://www.pgadmin.org/.

• Cd to the folder of your app and run to find out the name of your current database:

heroku pg:info

• Using that name run:

heroku pg:credentials name_of_the_database

• Add a new connection in PG Commander using the paramaters returned in "Connection info string" string attribute.