Re: Select between two connections

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(at)lighthouseasp(dot)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