pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPerform a Select on an Oracle Database from PG
2+ messages / 2 participants
[nested] [flat]
* Perform a Select on an Oracle Database from PG
@ 2002-12-19 15:37 val@webtribe.net
2002-12-19 16:05 ` Re: Perform a Select on an Oracle Database from PG Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: val@webtribe.net @ 2002-12-19 15:37 UTC (permalink / raw)
To: 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!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Perform a Select on an Oracle Database from PG
2002-12-19 15:37 Perform a Select on an Oracle Database from PG val@webtribe.net
@ 2002-12-19 16:05 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto Mello @ 2002-12-19 16:05 UTC (permalink / raw)
To: val@webtribe.net; +Cc: pgsql-sql
On Thu, Dec 19, 2002 at 03:37:00PM +0000, val@webtribe.net wrote:
> 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?
Write a program in some language that can access both databases. SELECT
data from Oracle and INSERT into PostgreSQL.
That assumes the database structure has already been migrated.
You might want to look at conversion tools in the PostgreSQL contrib tree
(see ftp site) and related articles at http://techdocs.postgresql.org/
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
All true wisdom is found in taglines.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-12-19 16:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-19 15:37 Perform a Select on an Oracle Database from PG val@webtribe.net
2002-12-19 16:05 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox