Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4FNvIA49127 for ; Tue, 15 May 2001 19:57:18 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f4FNSj566255 for pgsql-sql@postgresql.org; Tue, 15 May 2001 19:28:45 -0400 (EDT) (envelope-from news) From: Per-Olof Pettersson X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Select between two connections Date: Tue, 15 May 2001 23:30:15 GMT Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 51 Message-ID: <20010515.23301529@mis.configured.host> References: <3B0186D7.DD59D461@lighthouseasp.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Complaints-To: scrappy@hub.org X-Priority: 3 (Normal) X-Newsreader: Mozilla/3.0 (compatible; StarOffice/5.2;Win32) To: pgsql-sql@postgresql.org Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id f4FNvKA49133 X-Archive-Number: 200105/154 X-Sequence-Number: 2971 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