Re: Query from different Database

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Query from different Database
Date: 2004-10-07 20:58:08
Message-ID: 20041007205808.99643.qmail@web50001.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

--- Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
escribió:
> When grilled further on (Thu, 7 Oct 2004 16:52:38
> +0800 (MYT)),
> Abdul Wahab Dahalan <wahab(at)mimos(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michelle Murrain 2004-10-08 03:03:07 help on a query
Previous Message Robert Creager 2004-10-07 14:05:46 Re: Query from different Database