Bug in JDBC.driver CopyManager method when copying json output
"David G. Johnston" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.jdbc |
|---|---|
| Message-ID | <CAKFQuwbH-kJyMGPoMGQdW_FscojOZd60zqDX+SUPEBhZZ86ooA@mail.gmail.com> |
The backend is respecting the documented meanings and usage of the QUOTE and ESCAPE options of COPY. Not sure what a JSON mode would look like though I’m thinking it’s not what was described here... For now you either need to fiddle with those options of COPY or avoid it and generate your own output document. Didn’t try but I do presume feeding the output to COPY FROM reaults in a valid import. David J. On Saturday, October 20, 2018, Dave Cramer <[email protected]> wrote: > I suggest this is a backend problem... > > > > On Fri, 19 Oct 2018 at 10:12, Stadlmann, Gerson <[email protected]> > wrote: > >> Dear JDBC-Devs, >> >> i think i found an escaping bug that causes duplicate escaping with >> backslash when using jdbc drivers CopyManager with JSON results. >> >> >>