Re: FW: Multiple databases question

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(at)proteus-tech(dot)com]
Sent: Wednesday, February 12, 2003 4:29 PM
To: Jagaraj, Peter; pgsql-odbc(at)postgresql(dot)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(dot)jagaraj(at)gmacrfc(dot)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