[SQL] accessing database without a persistent connection

2005-06-19 Thread mohammad izwan ibrahim
Hi there, I need help on accessing few database without having a persistent connection. So far accessing via dblink still require persistent database connecttion. Is it possible to be done by postgress..and how to acheive that tq ---(end of broadcast)

Re: [SQL] accessing multiple database

2005-05-05 Thread mohammad izwan ibrahim
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" To: "mohamma

[SQL] accessing multiple database

2005-05-04 Thread mohammad izwan ibrahim
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. Tq ---(end of broadcast)--