Re: Select between two databases - Mailing list pgsql-sql

From Indraneel Majumdar
Subject Re: Select between two databases
Date
Msg-id Pine.SGI.3.96.1000924235807.98340A-100000@www.cdfd.org.in
Whole thread Raw
In response to Re: Select between two databases  (Fredrick Bartlett <palmtreefrb@earthlink.net>)
Responses  (Keith Wong <keith@e-magine.com.au>)
List pgsql-sql
Not working, but thanks anyway. Can anyone point out the relevant area of
the source where queries are handled?

Thanks,
Indraneel 

On Sun, 24 Sep 2000, Fredrick Bartlett wrote:

> Not sure if same can be accomplished with different servers.
> Try the following for database's on one server,  use alias & dot notation...
> 
> select a1.colA1 from
> myDatabase1.tableA1 a1
> where a1.A2 in (select b1.colB1 from myDatabase2.tableB1 b1)
> 

/************************************************************************.
# 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: Fredrick Bartlett
Date:
Subject: Re: Select between two databases
Next
From: Stephan Szabo
Date:
Subject: Re: Select between two databases