heroku - How to hide databases that I am not allowed to access

Question

When I connect to my Heroku - Postgresql database via pgAdmin3, It lists all the tables (about 2600). Every time I open the pgAdmin3 I have to find my own database.

Is there a way to hide databases that I'm not allowed to access ?

Answer 1

Had the same issue, as its a shared space on AWS with 1000 other DBs.

pgAdmin 3

1. Make sure you are disconnected from your server.
2. Right click your Server -> properties -> Advanced tab.
3. In 'DB restriction' type in the name of your database(s) enclosed in single quotes and separated by spaces. E.g. 'dback447'

pgAdmin 4

Same as above, but on step 3 do not use quotes, just the plain DB name. E.g dback447