DBeaver 只能在连接中看到默认的 PostgreSQL 数据库

我在 Windows 上使用 DBeaver v 5.2.5，并用它连接 PostgreSQL 数据库。

要创建连接，我必须指定数据库，而且我无法查看同一服务器上的其他数据库。

一位在 Mac 上使用 DBeaver 5.3的同事有一个查看所有数据库的选项，而不仅仅是默认数据库。

在 Windows 版本上是否有等效的设置？

34914 次浏览

小开

Today I had to reinstall DBeaver on a new machine and this time, I let DBeaver download the postgresql drivers.

In this case, I can see the other databases so I can only assume that it was due to the jdbc drivers I loaded

小开

最佳答案

On the connection, right-click -> Edit connection -> Connection settings -> on the tabbed panel, select PostgreSQL, check the box Show all databases.

小开

The same problem in DBeaver 21.3.1, Postgress 14.1 installed with brew on MacOS Catalina. I've solved it in the Connection settings:

On the connection, right-click -> Edit connection -> Connection settings -> then click button "Edit Driver Settings", check "Embedded" checkbox.

小开

2023 Update...

Right-click on your connection
Click "Edit connection"
Left panel, click "Connection settings"
Select PostgreSQL tab Check the box "Show all databases"