Thread: PostgresQL Connection Question

PostgresQL Connection Question

From

"Gavin M. Roy"

Date:

21 September 2000, 20:58:33

Is it possible in one sql statement to query tables from multiple
databases?

Thanks in Advance,

Gavin

Re: PostgresQL Connection Question

From

"Anthony E . Greene"

Date:

27 September 2000, 11:21:52

On Thu, 21 Sep 2000 17:58 Gavin M. Roy wrote:
>Is it possible in one sql statement to query tables from multiple
>databases?

No. The query is sent to the backend over a connection to a specific
database. You will need to create separate queries for each database and send the
appropriate query to each one.

It's not too hard. There is more error checking involved, but I had to do
it in one of my applications and found that it's not much more trouble.

--
Anthony E. Greene <agreene@pobox.com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26  C484 A42A 60DD 6C94 239D
AIM: TonyG05    ICQ: 91183266    Jabber: TonyGreene
Linux. The choice of a GNU Generation. <http://www.linux.org/>