Cross DB Queries

From: "Gavin M(dot) Roy" <gmr(at)readysetnet(dot)com>
To: pgsql list <pgsql-admin(at)postgresql(dot)org>
Subject: Cross DB Queries
Date: 2000-10-30 19:17:03
Message-ID: 39FDC92F.3F68DFFB@readysetnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Igor N. Avtaev 2000-10-31 08:32:44 FATAL: 1 Memory exhausted in AllocSetAlloc()
Previous Message Dr. Hans-Christian Waldmann 2000-10-30 10:11:28