RE: Accessing two differents database in a SELECT

From: Nicolas Huillard <nhuillard(at)ghs(dot)fr>
To: "'herve(at)elma(dot)fr'" <herve(at)elma(dot)fr>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Accessing two differents database in a SELECT
Date: 2001-06-07 09:48:24
Message-ID: 01C0EF47.C2BC2300.nhuillard@ghs.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)elma(dot)fr]
> Date: jeudi 7 juin 2001 11:20
> À: pgsql-general(at)postgresql(dot)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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-07 09:49:59 Re: USE_AUSTRALIAN_RULES breaks regression tests in 7.1.2?
Previous Message Mourad EL HADJ MIMOUNE 2001-06-07 09:41:56 the use of expressions instead of simple values in array insertion?