I am using Heroku to host a number of apps. Some of them have PG databases that are on shared servers. When that
happens,there could be hundreds of databases on a single server (each with a randomly-generated name), but only one of
themis the one I’m interested in (and that’s the only one that I have access to).
When I add the database to pgAdmin4, I provide the host address, username, password, and database name. But there seems
tobe no way to directly open a connection to that database. I must first open the server, then click on “Databases”,
thenfind my database from among the hundreds listed, and only then can I establish a connection to the database.
Is there a shortcut to just use the connection info that I have provided to go straight to the database? If not, then I
wouldsuggest that such a feature ought to be fast-tracked. For example, you might add a “Open database xxx” command to
thecontext menu on the server, where the “xxx” is the database name.
Another option would be to use the server credentials to determine which databases I have access to, and only list the
onesthat are available to me. If you don’t want this behavior to apply to all databases, then add a flag on the
“Advanced”tab of the server properties that would toggle between this behavior and the current behavior.
Regards,
Jack