Re: Bug: COPY FORMAT JSON includes generated columns unlike text/CSV - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Bug: COPY FORMAT JSON includes generated columns unlike text/CSV
Date
Msg-id a2fe8b41-b2ac-4e17-a43b-8cb484796673@dunslane.net
Whole thread
In response to Re: Bug: COPY FORMAT JSON includes generated columns unlike text/CSV  (jian he <jian.universality@gmail.com>)
List pgsql-hackers


On 2026-04-14 Tu 10:46 AM, jian he wrote:
On Mon, Apr 13, 2026 at 5:21 PM SATYANARAYANA NARLAPURAM
<satyanarlapuram@gmail.com> wrote:
Hi hackers,

COPY TO with FORMAT json includes generated columns in the output,
while text and CSV formats correctly exclude them.  Virtual generated
columns appear as null (since they aren't materialized), and stored
generated columns appear with their values  Attached a patch to address this.

The patch looks good to me.

It seems there's a ``git apply`` issue applying the V1 patch.
The attached v2 is the same as your v1, it should apply without issue
using `git apply` or `git am`.



Thanks. pushed.


cheers


andrew

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

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Add errdetail() with PID and UID about source of termination signal
Next
From: Kirill Reshke
Date:
Subject: Re: Add errdetail() with PID and UID about source of termination signal