Postgres Pro
Downloads
Home   >   mailing lists

Bug in JDBC.driver CopyManager method when copying json output - Mailing list pgsql-jdbc

From David G. Johnston
Subject Bug in JDBC.driver CopyManager method when copying json output
Date
Msg-id CAKFQuwbH-kJyMGPoMGQdW_FscojOZd60zqDX+SUPEBhZZ86ooA@mail.gmail.com
Whole thread Raw
In response to Re: Bug in JDBC.driver CopyManager method when copying json output  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: Bug in JDBC.driver CopyManager method when copying json output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Tree view
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 <pg@fastcrypt.com> wrote:
I suggest this is a backend problem...



On Fri, 19 Oct 2018 at 10:12, Stadlmann, Gerson <Gerson.Stadlmann@ifco.com> 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.


pgsql-jdbc by date:

Previous
From: "Stadlmann, Gerson"
Date:
Subject: Re: ⚠ Re: Bug in JDBC.driver CopyManager method when copying json output
Next
From: Dave Cramer
Date:
Subject: Re: ⚠ Re: Bug in JDBC.driver CopyManager method when copying json output