Vincent, If you need to use just one connection against multiple databases, you should check out Virtuoso. Among other features it can act as a "virtual database", where you link multiple heterogenous database tables through it and then can treat them as one transparent schema from a single ODBC connection.
The databases you link can be on different platforms as well. You can combine remote data with data in Virtuoso's own tables, and do some interesting things like create XML documents on the fly from any combination of your relational data. http://www.openlinksw.com/virtuoso/whatis.htm Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Vincent Ma [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 29, 2002 8:46 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] same connection to access two different database? > > > Hi everyone: > > is it possible to use one connect to access two database in postgreq, > because i would like to use subquery to do same search. on the fly in > postgreq must faster a lot than evaluate in php code... > > A, B belong to different database... > sql : select * from A in ( select * B) > > Vincent Ma > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]