Re: Heterogeneous service (like Oracle or Ms SQL Server) - Mailing list pgsql-general

From Dann Corbit
Subject Re: Heterogeneous service (like Oracle or Ms SQL Server)
Date
Msg-id D90A5A6C612A39408103E6ECDD77B8294CDC7C@voyager.corporate.connx.com
Whole thread Raw
In response to Heterogeneous service (like Oracle or Ms SQL Server)  ("Mirco Tamburini" <mircotamburini@libero.it>)
List pgsql-general
> -----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

pgsql-general by date:

Previous
From: Fernando Schapachnik
Date:
Subject: Re: MSSQL -> PostgreSQL
Next
From: Network Administrator
Date:
Subject: Re: MSSQL -> PostgreSQL