Select between two databases - Mailing list pgsql-sql

From Indraneel Majumdar
Subject Select between two databases
Date
Msg-id Pine.SGI.3.96.1000924171306.91135C-100000@www.cdfd.org.in
Whole thread Raw
Responses Re: Select between two databases
List pgsql-sql
Hi,

Does any one know how I may select between two databases running on same
machine or on different machines eg.

select colA1 from tableA1 where colA2 in (select colB1 from tableB1);

here tableA1 and tableB1 are in different databases. The two databases
might be under the same postmaster or on different machines under
different postmasters. How do I query both simultaneously? Is it possible?

Thanks,
Indraneel

/************************************************************************.
# Indraneel Majumdar                  ¡  E-mail: indraneel@123india.com  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/



pgsql-sql by date:

Previous
From: Philip Warner
Date:
Subject: RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?
Next
From: Fredrick Bartlett
Date:
Subject: Re: Select between two databases