Received: from exchserv.Routescape.com (mail.routescape.com [151.196.108.77]
	(may be forged))
	by hub.org (8.10.1/8.10.1) with ESMTP id e7EJBJw45541
	for <pgsql-interfaces@hub.org>; Mon, 14 Aug 2000 15:11:20 -0400 (EDT)
Received: from DARRENK ([10.0.0.87]) by exchserv.Routescape.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2650.21)
	id Q22LP6G0; Mon, 14 Aug 2000 15:11:07 -0400
From: "Darren King" <darrenk@insightdist.com>
To: <pgsql-interfaces@hub.org>
Cc: <garza@keyframe.cjas.org>
Subject: RE: Migration
Date: Mon, 14 Aug 2000 15:04:46 -0400
Message-ID: <NDBBJNEIGLIPLCHCMANLCECACFAA.darrenk@insightdist.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
In-reply-to: <Pine.BSF.4.10.10008141404500.31876-100000@localhost>
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Importance: Normal
X-Archive-Number: 200008/92

> I've got another question for anybdy that's done Postgres -> Oracle
> migrations.  Is there a way for oracle's sqlpls to do a read from <stdin>
> like psql does with the pg_dump files? Or am i going to have to take this
> pg_dump file and replace all the <stdin> lines with INSERT lines?
> 
> Or, is there a way for pg_dump to just dump sql only?

How about coming up with a control file and using SQL*Loader?

Darren