sql select thru multiple postgres databases

Question

is there a way to create a select statement that would retrieve data from multiple database in postgre?

i was thinking it would be something like this:

select * from dbname1.table1, dbname2.table2 where dbname1.table1.column1 = dbname2.table2.column1

Answer 1

Have a look at the "dblink" contrib module.

OTOH it's possible that you treat the databases in a PostgreSQL cluster as equivalent to the databases in... let's say MySQL. Which is incorrect - the PostgreSQL databases contain schemas and those are the equivalent of the databases in MySQL.

Answer 2

From here:

It is not possible to access more than one database per connection.

Update: but see Milen's answer.