Thread: accessing multiple database

hi all,

im finding some ideas, method, advice, n etc on accessing multiple database.The system that i'm currently develop is
realtime update and the data reside on few different db at different db site. Tq in advance. 
 

Tq

am  05.05.2005, um 10:47:12 +0800 mailte mohammad izwan ibrahim folgendes:
> hi all,
> 
> im finding some ideas, method, advice, n etc on accessing multiple
> database.The system that i'm currently develop is real time update and
> the data reside on few different db at different db site. Tq in
> advance. 

1. write your own client thats connect to several databases
2. use dblink, this is part of the contrib-distribution


Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    === 

mohammad izwan ibrahim wrote:
> hi all,
> 
> im finding some ideas, method, advice, n etc on accessing multiple
> database.The system that i'm currently develop is real time update
> and the data reside on few different db at different db site. Tq in
> advance.

Obviously you can access more than one database from your client 
software. From within PostgreSQL itself, look into the dblink package in 
the contrib/ directory of the source distribution.

--   Richard Huxton  Archonet Ltd

Hi Richard Huxton, 
Tq for your advice, Hope you can help me on this

1.can I  create view from dblink  query
2.can I fetch the data simultaneous from multiple database using dblink function, how the syntax would be?


tq

-- Original message --
From: "Richard Huxton" <dev@archonet.com>
To: "mohammad izwan ibrahim" <izwan@orenda.com.my>
Date: Thursday 5 May 2005 15:06:24
Subject: Re: [SQL] accessing multiple database

> mohammad izwan ibrahim wrote:
> > hi all,
> > 
> > im finding some ideas, method, advice, n etc on accessing multiple
> > database.The system that i'm currently develop is real time update
> > and the data reside on few different db at different db site. Tq in
> > advance.
> 
> Obviously you can access more than one database from your client 
> software. From within PostgreSQL itself, look into the dblink package in 
> the contrib/ directory of the source distribution.
> 
> -- 
>    Richard Huxton
>    Archonet Ltd
> 

mohammad izwan ibrahim wrote:
> Hi Richard Huxton, Tq for your advice, Hope you can help me on this
> 
> 1.can I  create view from dblink  query

I believe so - see the dblink docs for details.

> 2.can I fetch the data simultaneous from multiple database using
> dblink function, how the syntax would be?

Not in one function-call, but I don't see why you couldn't have several 
sub-queries, each to a different database. I recommend testing it to see.

--   Richard Huxton  Archonet Ltd