pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
select from multiple databases on different machines
2+ messages / 2 participants
[nested] [flat]

* select from multiple databases on different machines
@ 2000-03-03 09:49  Anjan Borthakur <anjan@bombay.retortsoft.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Anjan Borthakur @ 2000-03-03 09:49 UTC (permalink / raw)
  To: pgsql-interfaces

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




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

* RE: [INTERFACES] select from multiple databases on different machines
@ 2000-03-03 11:59  Stephen Martin <stephen@sealteam.demon.co.uk>
  parent: Anjan Borthakur <anjan@bombay.retortsoft.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Stephen Martin @ 2000-03-03 11:59 UTC (permalink / raw)
  To: pgsql-interfaces

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


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




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


end of thread, other threads:[~2000-03-03 11:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-03-03 09:49 select from multiple databases on different machines Anjan Borthakur <anjan@bombay.retortsoft.com>
2000-03-03 11:59 ` Stephen Martin <stephen@sealteam.demon.co.uk>

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