Skip site navigation (1) Skip section navigation (2)

Re: is possible to read Oracle table from PostgreSQL?

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 (view raw or flat)
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




In response to

pgsql-odbc by date

Next:From: markwDate: 2003-10-16 17:44:43
Subject: Re: is possible to read Oracle table from PostgreSQL?
Previous:From: Stefanos KarasavvidisDate: 2003-10-16 12:05:13
Subject: link tables with VB from Access fails with 7.3.01 Unicode Beta

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group