pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephen Martin <stephen@sealteam.demon.co.uk>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] select from multiple databases on different machines
Date: Fri, 3 Mar 2000 03:59:29 -0800
Message-ID: <NDBBKKNKKLBACABPPCCNMEECDPAA.stephen@sealteam.demon.co.uk> (raw)
In-Reply-To: <Pine.LNX.4.10.10003031514240.27214-100000@alice.bombay.retortsoft.com>

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


************




view thread (2+ messages)

Message-ID: <NDBBKKNKKLBACABPPCCNMEECDPAA.stephen@sealteam.demon.co.uk>
Permalink:  ../NDBBKKNKKLBACABPPCCNMEECDPAA.stephen@sealteam.demon.co.uk/
Also on:    postgresql.org/message-id/NDBBKKNKKLBACABPPCCNMEECDPAA.stephen@sealteam.demon.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: stephen@sealteam.demon.co.uk
  Subject: RE: [INTERFACES] select from multiple databases on different machines
  In-Reply-To: <NDBBKKNKKLBACABPPCCNMEECDPAA.stephen@sealteam.demon.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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