RE: Migration - Mailing list pgsql-interfaces

From Darren King
Subject RE: Migration
Date
Msg-id NDBBJNEIGLIPLCHCMANLCECACFAA.darrenk@insightdist.com
Whole thread Raw
In response to Re: Migration  (John David Garza <garza@cjas.org>)
List pgsql-interfaces
> 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


pgsql-interfaces by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: Migration
Next
From: Mike Mascari
Date:
Subject: Re: Migration