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:herve@elma.fr]
> Date: jeudi 7 juin 2001 11:20
> À: pgsql-general@postgresql.org
> 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