Thread: Heterogeneous service (like Oracle or Ms SQL Server)

There is a concept of Database link?
Oracle Heterogeneous service (Trasparent gateway for ODBC) can create a link
to odbc database and the yuo can query 2 table across 2 different DB.


Select products.* , customer.name
from products, customer@accessdb
where products.id=customer.id

> -----Original Message-----
> From: Mirco Tamburini [mailto:mircotamburini@libero.it]
> Sent: Monday, May 12, 2003 9:20 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Heterogeneous service (like Oracle or Ms
> SQL Server)
>
>
> There is a concept of Database link?
> Oracle Heterogeneous service (Trasparent gateway for ODBC)
> can create a link to odbc database and the yuo can query 2
> table across 2 different DB.

Various ODBC database drivers can do this.  You can also use MS Access
or something of that ilk and join from there.
PostgreSQL does not have a database link.

> Select products.* , customer.name
> from products, customer@accessdb
> where products.id=customer.id

On Mon, May 12, 2003 at 06:19:49PM +0200, Mirco Tamburini wrote:
> There is a concept of Database link?
> Oracle Heterogeneous service (Trasparent gateway for ODBC) can create a link
> to odbc database and the yuo can query 2 table across 2 different DB.

There is a dblink module in contrib that may do what you want.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington