Re: [PG19] COPY (query) TO ... (FORMAT json) uses the table's column names

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: shihao zhong <zhong950419(at)gmail(dot)com>, Joao Detomini <joao(dot)detomini(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Joe Conway <mail(at)joeconway(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>
Subject: Re: [PG19] COPY (query) TO ... (FORMAT json) uses the table's column names
Date: 2026-10-06 21:38:57
Message-ID: b7aa485e-1603-4708-b1c7-29c9d8173198@dunslane.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 2026-10-05 Mo 9:04 PM, shihao zhong wrote:
> Hi Andrew,
>
> > Please test this out and see if you can break it again ;-)
>
> v2 looks good to me, and I could not break it with my previous
> tests.
>
> > so we can keep the copy and just pass it the
> > query's descriptor.
>
> I think that makes sense, haven't thought about performance impact
> at v1.
>
>

OK thanks to both of you. I will wait a day or so in case anyone else
wants to chime in, and commit late Thursday or Friday morning.

cheers

andrew

--
Andrew Dunstan
EDB:https://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tristan Partin 2026-10-06 21:41:31 Re: Fix out-of-bounds array indexing in JsonValueList
Previous Message Andrew Dunstan 2026-10-06 21:22:37 Re: Add ASCII fast path to Unicode normalization functions