How to hide databases that I am not allowed to access
pgAdmin 4 does not contain the 'DB Restriction' which is the only reason I am not using it, forcing me to settle for pgAdmin 3.
There was a ticket opened up to add this functionality in pgAdmin 4 ... https://redmine.postgresql.org/issues/1918
Had the same issue, as its a shared space on AWS with 1000 other DBs.
pgAdmin 3
- Make sure you are disconnected from your server.
- Right click your Server -> properties -> Advanced tab.
- 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
pgAdmin 4 version 6.1
Same as above, but press Tab after entering the name of each database. Commas or spaces take your string as a name of one single database.
And you have to press Tab even if you want to type only one database name, otherwise the Save button ignores your changes.
