Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cross DB Queries

Cross DB Queries

From
"Gavin M. Roy"
Date:
Is there slated, or does the ability already exist to query multiple
db's through the same sql statement?

SELECT db1.table1.*, db2.table2.* FROM db1.table1, db2.table2 WHERE
db1.table1.id = db2.table2.id;

TIA,

Gavin