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

> -----Original Message-----
> From: Mirco Tamburini [mailto:mircotamburini(at)libero(dot)it]
> Sent: Monday, May 12, 2003 9:20 AM
> To: pgsql-general(at)postgresql(dot)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(at)accessdb
> where products.id=customer.id