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
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.
johnoli...@rtzassoc