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-08 17:48:18
Message-ID: 05cc493c-26ff-407c-aad8-fc968aca5c87@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.
>
>

Thanks, committed.

cheers

andrew

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhao Song 2026-10-08 18:04:18 Re: Remove redundant MultiXactIdIsRunning() check in HeapTupleSatisfiesUpdate()
Previous Message Andrew Dunstan 2026-10-08 17:28:45 Re: [PG19]pg_verifybackup never finishes on a gzip-compressed tar backup