List all databases in PostgreSQL Server

[angel3cu]

I noticed that the driver only lists the database the user is connected to. Is it possible to support displaying all the databases in the list? I could potentially help with some code changes.

[mtxr]

we need to check if it's feasiable by the driver.

Show the list it's possible, i'm pretty sure, but we need to understand how would we query having multiple databases shown for a connection.

@angel3cu Have you tried something there? do you have any ideas we could bring to discussion?

[KateYoak]

I think it's a nice idea. Toggle the active database, just like we toggle active connection.

[poidstotal]

Any update on this feature? I badly need it.

[poidstotal]

A workaround would be to add a feature to duplicate existing connection for one to change only the database/connection name.

Can anyone direct on where the JSON for exiting connections being are saved? It would be helpful to copy/paste and modify. I've added new connection in the settings but there are not showing up on the connections list.

[gjsjohnmurray]

A workaround would be to add a feature to duplicate existing connection for one to change only the database/connection name.

Can anyone direct on where the JSON for exiting connections being are saved? It would be helpful to copy/paste and modify. I've added new connection in the settings but there are not showing up on the connections list.

In either User or Workspace settings. See https://code.visualstudio.com/docs/getstarted/settings for background information about VS Code's multilevel settings architecture.

[poidstotal]

Yeah got it's working now; Thanks!

[poidstotal]

Actually, i've noticed that if you specify mysql as the database to connect to, you will see the list of all other databases on the server.

[RickeyWard]

I would like to see this feature too, many postgres tools support this and its how many of us are used to working.

[gjsjohnmurray]

Related to #1152