| From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Davin Shearer <scholarsmate(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Emitting JSON to file using COPY TO |
| Date: | 2023-11-27 16:14:46 |
| Message-ID: | CAFCRh-90_b==6aS8DFMp8z46hmBCSDm_2wS28ob4QS+=E_dyOA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Mon, Nov 27, 2023 at 5:04 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 11/27/23 01:44, Dominique Devienne wrote:
> > On Mon, Nov 27, 2023 at 10:33 AM Dominique Devienne <ddevienne(at)gmail(dot)com
> > <mailto:ddevienne(at)gmail(dot)com>> wrote:
> > On second thought, I guess that's COPY in its text modes doing the
> escaping?
> > Interesting. The text-based modes of COPY are configurable. There's even
> > a JSON mode.
>
> Where are you seeing the JSON mode for COPY? AFAIK there is only text
> and CSV formats.
>
Indeed. Somehow I thought there was...
I've used the TEXT and BINARY modes, and remembered a wishful thinking JSON
mode!
OK then, if there was, then what I wrote would apply :). --DD
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dominique Devienne | 2023-11-27 18:16:01 | Ways to aggregate table info from variable number of schemas |
| Previous Message | Adrian Klaver | 2023-11-27 16:12:12 | Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2023-11-27 16:28:00 | Re: Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE |
| Previous Message | Adrian Klaver | 2023-11-27 16:04:05 | Re: Emitting JSON to file using COPY TO |