Re: [GENERAL] POSTGRES to ORACLE dump

2015-03-03 Thread John McKown
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

[GENERAL] POSTGRES to ORACLE dump

2015-03-03 Thread Oliver Dizon
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