How to show all databases for data source / host?

I know this is discussed a few times already. But it seems there is no solution or I am just missing it.

Is it not possible to list all databases for a host? In my current case for PostgreSQL.

This is pgAdmin

I basically like to have the same for DataGrip so that I don't have to create a new entry for each database on the host.

I tried by omitting a specific database name in the connection. But this does not give me a list of DBs.

Any help here?

9 comments
Comment actions Permalink

Correct, there is no solution currently, please follow the https://youtrack.jetbrains.com/issue/DBE-2287

0
Comment actions Permalink

Ok. Will do so. Just as a note, the link should be trimmed. It contains a trailing space that renders it invalid.

Sorry for double posting. But was not sure if the old topic is tracked or if my response there would just be lost.

Thanks for you fast reply!

0
Comment actions Permalink

Just in case anybody else is missing this go to the issue and vote the hell out of it as this is fairly essential :)

https://youtrack.jetbrains.com/issue/DBE-2287

0
Comment actions Permalink

Thanks you! Corrected the link.

0
Comment actions Permalink

I down-vote this proposition as keeping specific DB in the list keep it clear, and working on servers delivering multiple DBs can be a nightmare if all names are listed like in PGAdmin or Navicat.

An alternative should be to set an option to show/not show all databases, but not as a default.

-1
Comment actions Permalink

We are thinking about adding an option in Database window which would mean something like "show me more databases/schemas" if more schemas/db available. This would not pollute the view but it will be simple to discover.

For PostgreSQL unfortunately it is still not possible to have more than one database for a single connection (related issue is https://youtrack.jetbrains.com/issue/DBE-2287 ).

1
Comment actions Permalink

@Andrey Dernov: such option would be really nice

0
Comment actions Permalink

I am using postgres. I don't necessarily need multiple databases at once under a data source – just one at a time is workable as long as I can see a list of database to choose from. Currently, however, there doesn't seem to be a way to see a list of databases on a postgres instance/cluster.

Am I missing it? Do I literally have to know the database name in advance and type it into DataGrip?

0
Comment actions Permalink

Hi,

"Manage multiple databases in PostgreSQL" functionality will be available in next DataGrip EAP (https://youtrack.jetbrains.com/issue/DBE-2287)

Thank you.

0

Please sign in to leave a comment.