Re: Emitting JSON to file using COPY TO

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Junwang Zhao <zhjwpku(at)gmail(dot)com>
Cc: Joe Conway <mail(at)joeconway(dot)com>, "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Daniel Verite <daniel(at)manitou-mail(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Davin Shearer <davin(at)apache(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Emitting JSON to file using COPY TO
Date: 2025-10-01 06:16:42
Message-ID: CACJufxGbiNtsHnn=ZGw2J4VcjD5za5znbcxsaEvVd7vMdxQQ+g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Sun, Aug 10, 2025 at 11:20 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> v18-0001
> +typedef enum CopyFormat
> +{
> + COPY_FORMAT_TEXT = 0,
> + COPY_FORMAT_BINARY,
> + COPY_FORMAT_CSV,
> +} CopyFormat;
> remove CopyFormatOptions two boolean field
> (binary, csv_mode)
>
> v18-0002, v18-0003 is refactoring based on prior patch.

hi.
v19 attached, same as v18.
repost it so that CFbot can pick up the latest patchset.

Attachment Content-Type Size
v19-0002-json-format-for-COPY-TO.patch text/x-patch 22.6 KB
v19-0003-Add-option-force_array-for-COPY-JSON-FORMAT.patch text/x-patch 9.7 KB
v19-0001-introduce-CopyFormat-refactor-CopyFormatOptions.patch text/x-patch 12.7 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vu Le (JData - HN) 2025-10-01 07:47:29 Direct Major Upgrade (13.7 → 17.6) with pg_upgrade: Clarifying the need for Intermediate Minor Fixes/Scripts
Previous Message Rob Sargent 2025-09-30 20:24:48 Re: pg_hint_tables

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2025-10-01 06:26:50 Re: The ability of postgres to determine loss of files of the main fork
Previous Message Joel Jacobson 2025-10-01 05:47:27 Re: Optimize LISTEN/NOTIFY