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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
