I'm looking at the JDBC documentation at
https://jdbc.postgresql.org/documentation/head/index.html and not
seeing any mention of COPY and any semantics for using COPY FROM STDIN
or COPY TO STDOUT... google has a link to a 404 page with some sort of
CopyManager
we may need to develop a specialized sort of sql loader to replace an
existing Oracle tool, we need to intercept bad rows and put them in an
exceptions file, while bulk loading the good data. I'm thinking we
batch N rows into COPY, and if a row faults, put it in the exception
pool then retry the batch without it. the source data needs to be
massaged before it can be fed to copy, so we can't use COPY FROM
filename ...
--
john r pierce, recycling bits in santa cruz