Thread: Query from different Database

I'm looking for a solution to make a query  from two different databases.  If anybody has an experience or know how to
solveit, please help me. Thanks.
 

When grilled further on (Thu,  7 Oct 2004 16:52:38 +0800 (MYT)),
Abdul Wahab Dahalan <wahab@mimos.my> confessed:

> I'm looking for a solution to make a query  from two different databases.  If
> anybody has an experience or know how to solve it, please help me. Thanks.
> 

I believe that the contrib module dblink will do what you want, but I've never
used it.

Cheers,
Rob

-- 08:01:41 up 14 days, 10:28,  2 users,  load average: 3.27, 2.64, 2.34
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

 --- Robert Creager <Robert_Creager@LogicalChaos.org>
escribió: 
> When grilled further on (Thu,  7 Oct 2004 16:52:38
> +0800 (MYT)),
> Abdul Wahab Dahalan <wahab@mimos.my> confessed:
> 
> > I'm looking for a solution to make a query  from
> two different databases.  If
> > anybody has an experience or know how to solve it,
> please help me. Thanks.
> > 
> 
> I believe that the contrib module dblink will do
> what you want, but I've never
> used it.
> 

What about using schemas not databases. Selects
between schemas are fully supported.

Regards,
Jaime Casanova


_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com