Using DBeaver to query a PostgreSQL db and get following error: SQL Error [0A000]: ERROR: cross-database references are not implemented

Question

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!

Answer 1

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.

Answer 2

Add connection here

choose PostgreSQL and type in your connection:

finish setting up connection, connect to db and run

SELECT * FROM fs.ten_q_score;