Re: 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