Thread: FW: Multiple databases question

You don't say what your client environment is but I would probably lean towards writing up a very
small python app/script rather than bothering with ODBC. Python has excellent support for both
PostgreSQL and Oracle connectivity - and it works under just about any environment.

    good luck,

        Ben Scherrey

2/7/2003 2:29:14 PM, "Jagaraj, Peter" <peter.jagaraj@gmacrfc.com> wrote:
>  Here is the situation:
>
>  I have a bunch of tables in PostgreSQL. Our production db is Oracle running
>  on Unix. I would like to read records from PostgreSQL and insert them into
>
>  Oracle tables. Is there a simple way, say via PSQL or PL/SQL routine, to do
>  this?
>
>  Thanks

I am not familiar with Python, but it sounds like a good solution. However, if
you're stuck with ODBC I would like to share the following. About a year ago I
began looking into Oracle's Heterogeneous Connectivity (8.1.6) features to
create a database link between Oracle and PostgreSQL. I was able to establish
the link, but all queries returned errors. After investigating the log files I
came to the conclusion that the Oracle ODBC driver was creating SQL statements
that could not be interpreted properly by PostgreSQL because of the inconsistent
use of double-quotes around object names. So, if you are working strictly with
the databases I would suggest trying PostgreSQL+PSQL rather then Oracle+PL/SQL.
Personally, I would use PHP which also "has excellent support for both
PostgreSQL and Oracle connectivity - and it works under just about any
environment."

-- dave

snail: Madison WI 53707-7996
voice: 608.224.6227
fax: 608.224.6267


-----Original Message-----
From: Benjamin Scherrey [mailto:scherrey@proteus-tech.com]
Sent: Wednesday, February 12, 2003 4:29 PM
To: Jagaraj, Peter; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] FW: Multiple databases question


You don't say what your client environment is but I would probably lean towards
writing up a very
small python app/script rather than bothering with ODBC. Python has excellent
support for both
PostgreSQL and Oracle connectivity - and it works under just about any
environment.

    good luck,

        Ben Scherrey

2/7/2003 2:29:14 PM, "Jagaraj, Peter" <peter.jagaraj@gmacrfc.com> wrote:
>  Here is the situation:
>
>  I have a bunch of tables in PostgreSQL. Our production db is Oracle
> running  on Unix. I would like to read records from PostgreSQL and
> insert them into
>
>  Oracle tables. Is there a simple way, say via PSQL or PL/SQL routine,
> to do  this?
>
>  Thanks




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org