I am completely new to SQL, PostgreSQL, and DBeaver. When trying to simply query a table from a database:

SELECT * FROM operation.fs.ten_q_score;

I get the following error:

SQL Error [0A000]: ERROR: cross-database references are not implemented: "operation.fs.ten_q_score"ΒΆ  Position: 15

I have looked at the dblink, but do not even understand how to install something like dblink (even after looking at the actual documentation).

Any guidance is much appreciated!

2

There are 2 answers

1
Vao Tsun On BEST ANSWER

Add connection here

enter image description here

choose PostgreSQL and type in your connection:

enter image description here

finish setting up connection, connect to db and run

SELECT * FROM fs.ten_q_score;
2
Gh111 On

Maybe it will help someone, if you have several connection then you have to right click on connection your are going to work with and set it as active, after that when you press F3 button you will have an access to your currently selected database.

enter image description here