DBeaver how to switch database in sql editor

Question

I'm using DBeaver with Postgres. I can open a new sql editor with ctl+[.

But I have multiple databases in my Postgres. How can I have the sql editor run against another database? the following doesn't work

use <db name>;
select * from <table name>;

DatabaseShouter · Answer 1 · 2020-02-19T09:33:35.153

22

You can set a different database as active in your current connection by right-clicking in the Database Navigator pane and selecting "Set active", below I am switching from 'postgres' to my 'report_service' DB (this is version 6.1.2, not sure about other versions)

EDIT: I have recently upgraded to version 6.3.5 and this now has "Set as default" in the dropdown rather than "Set active" but this seems to be roughly the same behaviour

edited Feb 19 '20 at 09:33

answered Aug 29 '19 at 14:00

DatabaseShouter

814
9
11

In v6.3.0 is the same option. – EAmez Dec 20 '19 at 10:06
This does not work for me. With DBeaver 7.3.0 the command "Set as default" does not change the current database. Verified with `SELECT current_database();`. The other solution from @harry-moreno works well. – SebastianH Feb 24 '21 at 16:41
That's interesting, I'm now on 7.3.2 and it still works for me. – DatabaseShouter Feb 26 '21 at 10:23

score 17 · Accepted Answer · answered Feb 23 '19 at 05:57

17

You can change the currently selected database when you create new sql tabs by selecting it from the dropdown.

When you do so be sure to double-click on the schema you want to bring into focus. Then you can open new sql editors with ctrl+].

answered Feb 23 '19 at 05:57

Harry Moreno

10,231
7
64
116

1

In v6.3.0 this drop-down doesn't work fine and change selected DB is almost impossible. – EAmez Dec 20 '19 at 10:08

score 1 · Answer 3 · edited Feb 06 '23 at 16:57

1

I've found the solution. Press Ctrl+9 and choose your destiny-base...

Press Ctrl+9 and chooz

edited Feb 06 '23 at 16:57

Harry Moreno

10,231
7
64
116

answered Feb 06 '23 at 15:41

Kolya Titov

11
2

As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Feb 08 '23 at 17:33
The answer from @harry_moreno is perfect and bulls eye to the raised question. I have looked for month regularly having a go in Google but came up with nothing ... until now! Ctrl-9. Thanks Harry Moreno! – wideseen Aug 08 '23 at 07:00

DBeaver how to switch database in sql editor

3 Answers3