Hi Richard, That worked like a charm. Thanks!
> On Dec 1, 2020, at 6:45 PM, Richard Brockie <richard.broc...@gmail.com> wrote: > > Hi Jack, > > I've got 2 heroku databases up and running, one free "Hobby Dev", and one > production "Standard 0". > > To only address the "Hobby Dev" rather than pick from the long list, I've > added the database name to the "DB restriction" field on the Advanced tab of > the connection menu. I didn't have to do this for the "Standard 0" database > for some reason. > > R. > > > > On Tue, Dec 1, 2020 at 6:03 PM Jack Royal-Gordon <jac...@pobox.com > <mailto:jac...@pobox.com>> wrote: > 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 them is 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 to be no way to directly open a > connection to that database. I must first open the server, then click on > “Databases”, then find 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 would suggest that such a feature > ought to be fast-tracked. For example, you might add a “Open database xxx” > command to the context 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 ones that 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 > > > > -- > R. > > Richard Brockie > > Real-time bicycle race management - www.ontheday.net > <http://www.ontheday.net/>
