From: Per-Olof Pettersson <pgsql@peope.net>
To: pgsql-sql@postgresql.org
Subject: Re: Select between two connections
Date: Tue, 15 May 2001 23:30:15 GMT
Message-ID: <20010515.23301529@mis.configured.host> (raw)
References: <3B0186D7.DD59D461@lighthouseasp.com>
Hi
I think one way of accomplishing this is to use ODBC and thus an
ODBC-client for the selects.
There does not seem to be any support for it in Postgresql. (If not in
later versions).
Though I am not very experienced with it so someone more experienced
should perhaps answer the question.
Hopes this helps a little though.
Best regards
Peo
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2001-05-15, 22:15:38, cbell@lighthouseasp.com (cbell) wrote regarding
Select between two connections:
> Hello everyone, I would like to perform a Select statement that accesses
> tables and finds matching fields in two separate databases.
> For example, I have two connections to two separate database objects on
> the same
> Postgres server. I would like to retrieve information from a table in
> one database based on some information from tables in a different
> database.
> Has anyone done this before, can it be done?
> Thanks in advance,
> Chris.
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> http://www.postgresql.org/users-lounge/docs/faq.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pgsql@peope.net
Subject: Re: Select between two connections
In-Reply-To: <20010515.23301529@mis.configured.host>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox