Re: accessing multiple database

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(at)archonet(dot)com>
To: "mohammad izwan ibrahim" <izwan(at)orenda(dot)com(dot)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
>