Received: from ns1.foothill.net (ns1.foothill.net [206.170.175.1]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA96864 for ; Fri, 3 Mar 2000 06:56:06 -0500 (EST) (envelope-from stephen@sealteam.demon.co.uk) Received: from stephens (Q237.184.foothill.net [216.111.237.184]) by ns1.foothill.net (8.9.3/8.9.3) with SMTP id DAA22622 for ; Fri, 3 Mar 2000 03:51:06 -0800 (PST) From: "Stephen Martin" To: Subject: RE: [INTERFACES] select from multiple databases on different machines Date: Fri, 3 Mar 2000 03:59:29 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: Importance: Normal X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Hmm sounds like a job for perl DBD::pg ? :) Set up different db-file handles for each database connection instance? Or reuse same db-file handle 3 times interrogating 3 different db-instances, and fetch results back into separate arrays? Stephen ---------------------------------------------- 010000C9 -----Original Message----- From: owner-pgsql-interfaces@postgreSQL.org [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Anjan Borthakur Sent: Friday, March 03, 2000 1:49 AM To: pgsql-interfaces@postgreSQL.org Subject: [INTERFACES] select from multiple databases on different machines hi, how can i select from three different tables each located on three different machines ? i am using postgresql 6.52. on a red hat6.0 linux machine any help in this regard will be highly appreciated. thanks, -anjan borthakur ************