Postgres Pro
Downloads
Home   >   mailing lists

Re: Emitting JSON to file using COPY TO - Mailing list pgsql-hackers

From Davin Shearer
Subject Re: Emitting JSON to file using COPY TO
Date
Msg-id CALvfUkAbj4Bwg0FjYpvj0-zddcetWg1Sejt=OGBTDskbqOFS_A@mail.gmail.com
Whole thread Raw
In response to Re: Emitting JSON to file using COPY TO  (Joe Conway <mail@joeconway.com>)
Responses Re: Emitting JSON to file using COPY TO
List pgsql-hackers
Tree view
Thanks for the wayback machine link Andrew.  I read it, understood it, and will comply.

Joe, those test cases look great and the outputs are the same as `jq`.

As for forward slashes being escaped, I found this: https://stackoverflow.com/questions/1580647/json-why-are-forward-slashes-escaped.

Forward slash escaping is optional, so not escaping them in Postgres is okay.   The important thing is that the software _reading_ JSON interprets both '\/' and '/' as '/'.

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: backtrace_on_internal_error
Next
From: Nathan Bossart
Date:
Subject: Re: UBSan pointer overflow in xlogreader.c