Re: New "raw" COPY format

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Tatsuo Ishii" <ishii(at)postgresql(dot)org>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: New "raw" COPY format
Date: 2024-10-14 08:51:44
Message-ID: e7682d6d-9621-49bb-adb4-95057acdd978@app.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Oct 14, 2024, at 10:07, Joel Jacobson wrote:
> Attached is a first draft implementation of the new proposed COPY "raw" format.
>
> The first two patches are just the bug fix in HEAD, reported separately:
> https://commitfest.postgresql.org/50/5297/

I forgot about adding support for the old syntax format.
Fixed in new version. Only the fifth patch is updated.

Before, only the new syntax worked:
COPY .... (FORMAT raw);

Now this also works:
COPY ... RAW;

/Joel

Attachment Content-Type Size
v5-0001-Fix-thinko-in-tests-for-COPY-options-force_not_null-.patch application/octet-stream 4.6 KB
v5-0002-Fix-validation-of-FORCE_NOT_NULL-FORCE_NULL-for-all-.patch application/octet-stream 5.0 KB
v5-0003-Replace-binary-flags-binary-and-csv_mode-with-format.patch application/octet-stream 18.6 KB
v5-0004-Reorganize-ProcessCopyOptions-for-clarity-and-consis.patch application/octet-stream 19.9 KB
v5-0005-Add-raw-COPY-format-support-for-unstructured-text-da.patch application/octet-stream 37.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Anthonin Bonnefoy 2024-10-14 09:20:13 Re: Set query_id for query contained in utility statement
Previous Message Peter Smith 2024-10-14 08:45:25 Re: Add contrib/pg_logicalsnapinspect