How to specify the name of the base in Select?

Question

PostgreSQL

Can you please tell me how to specify the name of the database from which you want to select values ​​in the query?
There are 2 databases on 1 server, you need to form 1 large table in one of these databases in another database. Specifically, I would like to execute such a request:

INSERT into БАЗА1.foo_bar (foo_id, bar_id) ( 
  SELECT foo.id, bar.id FROM БАЗА2.foo JOIN bar 
    WHERE type = 'name' 
);

It is suitable to transfer the dump to another database and work with it there, but the possibility of such an implementation is of interest.

Answer 1

postgresql can't query tables in different databases. use dblink or postrges_fdw.

Answer 2

What's the question? The entry above is correct - "database.table"
Depending on the goals, you can also manually do it through mysqldump as an alternative.