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
>