How to connect pgAdmin to heroku postgresql

1.first of all you need to go to https://postgres.heroku.com/databases and click on the database you want to connect with.

2.And copy the host, database, name ,user,port,password .

3.Now open pgAdminIII client and click on add connection to servers button and paste the credential copied from the heroku ;  maintenance DB referrers to database name.

4. Then in the "Advanced" tab you must enter the maintenance DB name(Database name) surrounded with a single quotes.

  eg: 'dbname'



5.After that click on "ok" button done....!!!!

for further reference go to following links :

Connect to a heroku database with pgadmin

heroku postgresql How to hide databases that i am not allowed to access