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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
