pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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