Postgres Pro
Downloads
Home   >   mailing lists

Cross DB Queries - Mailing list pgsql-admin

From Gavin M. Roy
Subject Cross DB Queries
Date
Msg-id 39FDC92F.3F68DFFB@readysetnet.com
Whole thread Raw
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Dr. Hans-Christian Waldmann"
Date:
Subject: ...
Next
From: "Igor N. Avtaev"
Date:
Subject: FATAL: 1 Memory exhausted in AllocSetAlloc()