How to make a left join query from two tables in different databases in node, postgres?

Question

PostgreSQL

Hello!

There are two pools:

const pool = new Pool({
    host: 'db',
    user: 'postgres',
    password: 'pass',
    port: 5432,
    database: 'main', // и такой же пул, только с другим именем. В общем объекта два
});

How do I make a request like:

db(ТУТ использовать какой пулл?, второй или первой базы?).query(
  'SELECT db1.users.name FROM db1.users LEFT JOIN db2.rating on db1.users.id=db2.rating.user_id'
)

I would be very grateful for your help!

Answer 1

It is forbidden. This is not mysql, postgres does not support cross-db queries

Answer 2

From physically different databases, this will not work, just take data from two databases with your hands and join it in the code.
Unless your data is not in two databases, but in one, but different schemes, but then there is nowhere for two connections to come from.

Answer 3

Connect the base via FDW , then it will be possible to touch both in one request.