CODEWITHSUNDEEP
postgresqldbeaver
Graham Streich
Graham Streich

Reputation: 924

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

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!

Upvotes: 9

Views: 24313

Answers (2)

Gh111
Gh111

Reputation: 1452

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

Upvotes: 24

Vao Tsun
Vao Tsun

Reputation: 51599

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;

Upvotes: 7

Related Questions