From: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-interfaces@postgresql.org
Subject: Re: Migration
Date: Mon, 14 Aug 2000 13:41:49 -0500
Message-ID: <20000814134149.C8686@rice.edu> (raw)
In-Reply-To: <Pine.BSF.4.10.10008141404500.31876-100000@localhost>
References: <39705864.8CABD64F@radix.com.br>
<Pine.BSF.4.10.10008141404500.31876-100000@localhost>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: reedstrm@rice.edu
Subject: Re: Migration
In-Reply-To: <20000814134149.C8686@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox