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