Perform a Select on an Oracle Database from PG

From: val(at)webtribe(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: Perform a Select on an Oracle Database from PG
Date: 2002-12-19 15:37:00
Message-ID: 20021219153734.42ABB18332@cheetah.webtribe.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How do I do a cross-database connection?

I have data in a table in Oracle that I need to copy into a
Postgres table. It has been suggested to me that I attempt to
perform a cross-database select instead of exporting the info
from Oracle into a CSV file and then importing the CSV data into
Postres.

Can someone please advise me on how to do this or point me to
some documentation?

Thank you!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2002-12-19 16:05:38 Re: Perform a Select on an Oracle Database from PG
Previous Message Gary Stainburn 2002-12-19 15:22:30 Re: references table(multiple columns go here)