Date: Thu, 19 Dec 2002 09:05:38 -0700
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
Message-ID: <20021219160538.GB30522@cc.usu.edu>
References: <20021219153734.42ABB18332@cheetah.webtribe.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <20021219153734.42ABB18332@cheetah.webtribe.net>
User-Agent: Mutt/1.4i

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.