> -----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