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