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

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Joao Detomini <joao(dot)detomini(at)enterprisedb(dot)com>
Cc: andrew(at)dunslane(dot)net, 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 01:04:37
Message-ID: CAGRkXqR+N9JpT5tOK82=Z++jcvs-RJ6piuKNrnQTXmmTHoe2Rg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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,
Shihao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-10-06 01:15:49 [PG19]pg_verifybackup never finishes on a gzip-compressed tar backup
Previous Message shihao zhong 2026-10-06 01:00:12 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers