Postgres Pro
Downloads
Home   >   mailing lists

Perform a Select on an Oracle Database from PG - Mailing list pgsql-sql

From val@webtribe.net
Subject Perform a Select on an Oracle Database from PG
Date
Msg-id 20021219153734.42ABB18332@cheetah.webtribe.net
Whole thread Raw
Responses Re: Perform a Select on an Oracle Database from PG  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Tree view 
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!

pgsql-sql by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: references table(multiple columns go here)
Next
From: Roberto Mello
Date:
Subject: Re: Perform a Select on an Oracle Database from PG