I dont know anything about postgresql but a database independent way would be to independently connect to each database and get the results in some sort of a result set (STRUCT, XML string, char ** , etc.). Then do the merging and summarizing of the two result sets in your code.
Arvind ----- Original Message ----- From: "Devdas Bhagat" <[EMAIL PROTECTED]> To: "LIH" <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 9:19 PM Subject: [LIH] joining across multiple databases in postgresql > I have ended up with an application that needs reporting on some tables > from another database. I would prefer not to have to duplicate the whole > table ( duplication of a few thousand entries required in real time ). > Is it possible for the application to join across multiple postgresql > databases? > > A google search showed some stuff about mysql but nothing about > postgresql. > The application is in Java, and uses the native pg connectivity to > connect to the database server. > (MySQL syntax was: dbname1.tablename.colname='' and > dbname2.tablename.colname='') > > Thanks for any help > > Devdas Bhagat > > _______________________________________________ > linux-india-help mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/linux-india-help _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
