From: Roberto Mello <rmello@cc.usu.edu>
To: val@webtribe.net
Cc: pgsql-sql@postgresql.org
Subject: Re: Perform a Select on an Oracle Database from PG
Date: Thu, 19 Dec 2002 09:05:38 -0700
Message-ID: <20021219160538.GB30522@cc.usu.edu> (raw)
In-Reply-To: <20021219153734.42ABB18332@cheetah.webtribe.net>
References: <20021219153734.42ABB18332@cheetah.webtribe.net>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, val@webtribe.net
Subject: Re: Perform a Select on an Oracle Database from PG
In-Reply-To: <20021219160538.GB30522@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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