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

Re: Select between two databases

From: Indraneel Majumdar <indraneel(at)www(dot)cdfd(dot)org(dot)in>
To: Fredrick Bartlett <palmtreefrb(at)earthlink(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Select between two databases
Date: 2000-09-25 07:01:35
Message-ID: Pine.SGI.3.96.1000924235807.98340A-100000@www.cdfd.org.in (view raw or flat)
Thread:
Lists: 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(at)123india(dot)com  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/


In response to

Responses

  • at 2000-09-27 13:32:40 from Keith Wong

pgsql-sql by date

Next:From: Meszaros AttilaDate: 2000-09-25 16:56:16
Subject: Subqueries in from clause?
Previous:From: Philip WarnerDate: 2000-09-25 01:48:03
Subject: Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?

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