Using DBeaver to query a PostgreSQL db and get following error: SQL Error [0A000]: ERROR: cross-database references are not implemented
Solution 1
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;
Solution 2
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.
Graham Streich
Poetry -> Videography -> Math -> Economics -> Code -> Regulation -> National Security -> Law ->->-> (TBD)
Updated on June 14, 2022Comments
-
Graham Streich almost 2 years
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!