pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Select between two connections
2+ messages / 2 participants
[nested] [flat]

* Select between two connections
@ 2001-05-15 19:43 cbell <cbell@lighthouseasp.com>
  2001-05-15 23:30 ` Re: Select between two connections Per-Olof Pettersson <pgsql@peope.net>
  0 siblings, 1 reply; 2+ messages in thread

From: cbell @ 2001-05-15 19:43 UTC (permalink / raw)
  To: pgsql-sql

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.






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Select between two connections
  2001-05-15 19:43 Select between two connections cbell <cbell@lighthouseasp.com>
@ 2001-05-15 23:30 ` Per-Olof Pettersson <pgsql@peope.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Per-Olof Pettersson @ 2001-05-15 23:30 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-05-15 23:30 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-15 19:43 Select between two connections cbell <cbell@lighthouseasp.com>
2001-05-15 23:30 ` Per-Olof Pettersson <pgsql@peope.net>

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