Menu
I use DBeaver v 5.2.5 on Windows and use it to connect to PostgreSQL databases.
To create a connection, I must specify the database and I have no mean to see other databases on the same server.
A colleague using DBeaver 5.3 on Mac has an option to see all databases, not just the default one.
Is there an equivalent setup on the windows version?
636
On the connection, right-click -> Edit connection -> Connection settings -> on the tabbed panel, select PostgreSQL , check the box Show all databases .
Switching Databases Most Postgres servers have three databases defined by default: template0 , template1 and postgres . template0 and template1 are skeleton databases that are or can be used by the CREATE DATABASE command. postgres is the default database you will connect to before you have created any other databases.
A colleague using DBeaver 5.3 on Mac has an option to see all databases, not just the default one. Is there an equivalent setup on the windows version? On the connection, right-click -> Edit connection -> Connection settings -> on the tabbed panel, select PostgreSQL, check the box Show all databases.
Manage PostgreSQL data with visual tools in DBeaver like the query browser. The CData JDBC Driver for PostgreSQL implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools.
To connect to PostgreSQL, set the Server, Port (the default port is 5432), and Database connection properties and set the User and Password you wish to use to authenticate to the server. If the Database property is not specified, the data provider connects to the user's default database.
For more recent versions of DBeaver, you can improve this confusing default behavior. You need to change an "Editors" setting. There are several ways to get to the setting, an easy way is: After that, any time you click on a database in the right-hand navigator, it will automatically be set as the active database, so things should just work.
On the connection, right-click -> Edit connection -> Connection settings -> on the tabbed panel, select PostgreSQL, check the box Show all databases.
114
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
