Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id BC39F4767FD
	for <pgsql-sql@postgresql.org>; Thu, 19 Dec 2002 10:38:53 -0500 (EST)
Received: from klingon.netkonect.net (klingon.netkonect.co.uk [194.62.44.61])
	by postgresql.org (Postfix) with ESMTP id 05A00476185
	for <pgsql-sql@postgresql.org>; Thu, 19 Dec 2002 10:38:52 -0500 (EST)
Received: from cheetah.webtribe.net (cheetah.webtribe.net [194.164.194.4])
	by klingon.netkonect.net (8.11.4/8.11.4) with ESMTP id gBJFbFU02966
	for <pgsql-sql@postgresql.org>; Thu, 19 Dec 2002 15:37:15 GMT
Received: from localhost (cheetah.webtribe.net [194.164.194.4])
	by cheetah.webtribe.net (Postfix) with SMTP id 42ABB18332
	for <pgsql-sql@postgresql.org.>; Thu, 19 Dec 2002 15:37:34 +0000 (GMT)
Cc: 
Subject: Perform a Select on an Oracle Database from PG
Content-type: text/plain
X-mailer: WebMail 
Date: Thu, 19 Dec 2002 15:37 +0000
Content-transfer-encoding: 8bit
Mime-version: 1.0
To: pgsql-sql@postgresql.org
From: val@webtribe.net
Message-Id: <20021219153734.42ABB18332@cheetah.webtribe.net>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/241
X-Sequence-Number: 10829

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!