Re: [GENERAL] Accessing two differents database in a SELECT
I use MS Access as a front-end to PostgreSQL. Not only can I link tables from different PostgreSQL databases, but I can link tables from different ODBC compliant database products such as MySQL, MS Access, PostgreSQL, and Sybase. I hope this helps, Andrew Gould --- Hervé Piedvache <[EMAIL PROTECTED]> wrote: > Hi, > > How and is it possible to access to two differents > tables which are > stored in two differents database ? > > Will it be possible one day ? > > Thanks for your answers, > -- > Hervé > > ---(end of > broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
RE: [GENERAL] Accessing two differents database in a SELECT
If you use Perl, I think there is a DBI proxy driver. It works as a DBI driver for the script that uses the DB, but in fact redirects queries as a proxy, to whatever you want. Maybe it can redirect queries to many DB's ? You will just have problem with joins... NH > -Message d'origine- > De: Hervé Piedvache [SMTP:[EMAIL PROTECTED]] > Date: jeudi 7 juin 2001 11:20 > À:[EMAIL PROTECTED] > Objet:[GENERAL] Accessing two differents database in a SELECT > > Hi, > > How and is it possible to access to two differents tables which are > stored in two differents database ? > > Will it be possible one day ? > > Thanks for your answers, > -- > Hervé > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl ---(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