Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group