| Lists: | pgsql-odbc |
|---|
| From: | "Marco" <marko78(at)libero(dot)it> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | is possible to read Oracle table from PostgreSQL? |
| Date: | 2003-10-15 19:02:46 |
| Message-ID: | qRgjb.38549$vO5.1419143@twister1.libero.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
I need to know if is possible to read oracle tables from PostgresSQL.
Can someone give me some help?
Thanks a lot
| 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 |
| 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: | <markw(at)mohawksoft(dot)com> |
|---|---|
| To: | <marko78(at)libero(dot)it> |
| Cc: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: is possible to read Oracle table from PostgreSQL? |
| Date: | 2003-10-16 17:44:43 |
| Message-ID: | 53151.24.60.194.163.1066326283.squirrel@mail.mohawksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-odbc |
> 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.
But, in general, I'd say no.