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!
Add connection here
choose PostgreSQL and type in your connection:
finish setting up connection, connect to db and run