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