Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154])
	by hub.org (8.10.1/8.10.1) with ESMTP id e7EIfsw36858
	for <pgsql-interfaces@postgresql.org>;
	Mon, 14 Aug 2000 14:41:54 -0400 (EDT)
Received: by rice.edu via sendmail from stdin
	id <m13OPBF-000LGRC@wallace.ece.rice.edu> (Debian Smail3.2.0.102)
	for pgsql-interfaces@postgresql.org;
	Mon, 14 Aug 2000 13:41:49 -0500 (CDT)
Date: Mon, 14 Aug 2000 13:41:49 -0500
From: "Ross J. Reedstrom" <reedstrm@rice.edu>
To: pgsql-interfaces@postgresql.org
Subject: Re: Migration
Message-ID: <20000814134149.C8686@rice.edu>
Mail-Followup-To: pgsql-interfaces@postgresql.org
References: <39705864.8CABD64F@radix.com.br>
	<Pine.BSF.4.10.10008141404500.31876-100000@localhost>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <Pine.BSF.4.10.10008141404500.31876-100000@localhost>;
	from garza@cjas.org on Mon, Aug 14, 2000 at 02:08:27PM -0400
X-Archive-Number: 200008/91

On Mon, Aug 14, 2000 at 02:08:27PM -0400, John David Garza wrote:
> Hello all,
> 
> 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?

Perhaps one of the [dD] options will be of help?

wallace$ pg_dump --help 
pg_dump dumps a database as a text file.

Usage:
  pg_dump [options] dbname

Options:
  -a, --data-only          dump out only the data, not the schema
  -c, --clean              clean (drop) schema prior to create
  -C, --create             output commands to create database
  -d, --inserts            dump data as INSERT, rather than COPY, commands
  -D, --attribute-inserts  dump data as INSERT commands with attribute names
...

Ross
-- 
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> 
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005