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