COPY in Java?
| От | John R Pierce |
|---|---|
| Тема | COPY in Java? |
| Дата | |
| Msg-id | b4c16a4a-a410-38c5-becc-fc5f1d10cc7c@hogranch.com обсуждение исходный текст |
| Ответы |
Re: COPY in Java?
|
| Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: