How to query two postgres databases (with a single query) when the databases are within the same postgres server?

Viewed 9826

For example, assuming that table A is in database example and table B is in database postgres, how to perform the following query on the two tables?:

SELECT
 A.date,
 A.name,
 B.date,
 B.name
FROM A
INNER JOIN B ON A.name = B.name;

enter image description here

0 Answers
Related