| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | markw(at)mohawksoft(dot)com |
| Cc: | marko78(at)libero(dot)it, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: is possible to read Oracle table from PostgreSQL? |
| Date: | 2003-10-16 17:41:51 |
| Message-ID: | 3F8ED85F.7010604@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
markw(at)mohawksoft(dot)com wrote:
>>I need to know if is possible to read oracle tables from PostgresSQL.
>>Can someone give me some help?
>
>
> It is theoretically possible, but depending on your skill level, possible
> but difficult.
>
> Starting with the latest versions of PostgreSQL, it is possible to return
> multi-column result sets. All one would need to do is construct a
> PostgreSQL extension that would query the Oracle database and return the
> result set.
Hans-Jürgen Schönig modified contrib/dblink to do this. See:
http://archives.postgresql.org/pgsql-hackers/2003-06/msg00361.php
HTH,
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | markw | 2003-10-16 17:44:43 | Re: is possible to read Oracle table from PostgreSQL? |
| Previous Message | Stefanos Karasavvidis | 2003-10-16 12:05:13 | link tables with VB from Access fails with 7.3.01 Unicode Beta |