Re: POSTGRES to ORACLE dump

You might want to consider pg_dump with the --column-inserts option.
[quote from man ]
...
--column-inserts, --attribute-inserts
Dump data as INSERT commands with explicit column names
(INSERT INTO table (column, ...) VALUES ...). This will make
restoration very slow; it is mainly useful for making
dumps that can be loaded into non-PostgreSQL databases.
However, since this option generates a separate command for each row,
an error in reloading a row causes only that row
to be lost rather than the entire table contents.

[quote ends]

On Tue, Mar 3, 2015 at 3:59 AM, Oliver Dizon
<johnoliver(at)rtzassociates(dot)com> wrote:
> Hello,
>
> Is there a way to create a dump file of a Postgres DB to Oracle DB?
>
> I've found some ways using general snippets but I would like to know what is the best way to do it.
>
> Thanks
>
>
> Regards,
> ______________________
> Oliver G. Dizon
> Z Getcare Systems Team
> RTZ Associates, Inc.
> johnoliver(at)rtzassociates(dot)com
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown