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-08-10 15:20:12
Message-ID: CACJufxGF0F8ooTCCaY=PLhb-K84NOz=SYGjYF8ZrbgO8C0iFqQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

hi.

rebase and splitted into 3 patches.

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.

Attachment Content-Type Size
v18-0003-Add-option-force_array-for-COPY-JSON-FORMAT.patch text/x-patch 9.7 KB
v18-0002-json-format-for-COPY-TO.patch text/x-patch 22.6 KB
v18-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 Laurenz Albe 2025-08-10 19:34:19 Re: When UPDATE a row in a table with BEFORE ROW UPDATE trigger, the XMAX of new tuple is set to current XID
Previous Message Akashkiran Shivakumar 2025-08-10 03:00:28 Re: Can postgres replication slot using pgoutput release multiple CDC records for a single update to a particular row

Browse pgsql-hackers by date

  From Date Subject
Next Message Noah Misch 2025-08-10 16:36:59 Re: Test instability when pg_dump orders by OID
Previous Message Kirill Reshke 2025-08-10 11:41:20 Re: Test instability when pg_dump orders by OID