MIME-Version: 1.0
References: 
 <CAHg+QDcfpGDoPL3fvfjXRtfn=fny6DdJR6BAy6TpS1Xj2EZfXA@mail.gmail.com>
In-Reply-To: 
 <CAHg+QDcfpGDoPL3fvfjXRtfn=fny6DdJR6BAy6TpS1Xj2EZfXA@mail.gmail.com>
From: jian he <jian.universality@gmail.com>
Date: Tue, 14 Apr 2026 22:46:56 +0800
Message-ID: 
 <CACJufxEDsyWG0-k_yQszrDw9DpOU0Rvti6EJu5kmQ26HEbHQSw@mail.gmail.com>
Subject: Re: Bug: COPY FORMAT JSON includes generated columns unlike text/CSV
To: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	Richard Guo <guofenglinux@gmail.com>
Content-Type: multipart/mixed; boundary="000000000000e34205064f6cad1a"
Archived-At: 
 <https://www.postgresql.org/message-id/CACJufxEDsyWG0-k_yQszrDw9DpOU0Rvti6EJu5kmQ26HEbHQSw%40mail.gmail.com>
Precedence: bulk

--000000000000e34205064f6cad1a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Apr 13, 2026 at 5:21=E2=80=AFPM 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 t=
his.
>
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`.


--
jian
https://www.enterprisedb.com/

--000000000000e34205064f6cad1a
Content-Type: text/x-patch; charset="US-ASCII";
	name="v2-0001-COPY-FORMAT-JSON-with-generated.patch"
Content-Disposition: attachment;
	filename="v2-0001-COPY-FORMAT-JSON-with-generated.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnyqh7qy0>
X-Attachment-Id: f_mnyqh7qy0

RnJvbSA0MTNiYzcwYWFlZTllZmU4Y2Y0MDE1M2JiMzFjODBkZTY5ZjVhOTA5IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBqaWFuIGhlIDxqaWFuLnVuaXZlcnNhbGl0eUBnbWFpbC5jb20+
CkRhdGU6IE1vbiwgMTMgQXByIDIwMjYgMjI6NDg6NDcgKzA4MDAKU3ViamVjdDogW1BBVENIIHYy
IDEvMV0gQ09QWSBGT1JNQVQgSlNPTiB3aXRoIGdlbmVyYXRlZAoKQXV0aG9yOiAgCVNBVFlBTkFS
QVlBTkEgTkFSTEFQVVJBTSA8c2F0eWFuYXJsYXB1cmFtKGF0KWdtYWlsKGRvdCljb20+CmRpc2N1
c3Npb246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FIZyUyQlFEY2ZwR0RvUEwzZnZmalhSdGZuJTNE
Zm55NkRkSlI2QkF5NlRwUzFYajJFWmZYQSU0MG1haWwuZ21haWwuY29tCmNvbW1pdGZlc3QgZW50
cnk6IGh0dHBzOi8vY29tbWl0ZmVzdC5wb3N0Z3Jlc3FsLm9yZy9wYXRjaC8KLS0tCiBzcmMvYmFj
a2VuZC9jb21tYW5kcy9jb3B5dG8uYyAgICAgICAgICAgICAgICAgICB8IDIgKy0KIHNyYy90ZXN0
L3JlZ3Jlc3MvZXhwZWN0ZWQvZ2VuZXJhdGVkX3N0b3JlZC5vdXQgIHwgNiArKysrKysKIHNyYy90
ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ2VuZXJhdGVkX3ZpcnR1YWwub3V0IHwgNiArKysrKysKIHNy
Yy90ZXN0L3JlZ3Jlc3Mvc3FsL2dlbmVyYXRlZF9zdG9yZWQuc3FsICAgICAgIHwgMyArKysKIHNy
Yy90ZXN0L3JlZ3Jlc3Mvc3FsL2dlbmVyYXRlZF92aXJ0dWFsLnNxbCAgICAgIHwgMyArKysKIDUg
ZmlsZXMgY2hhbmdlZCwgMTkgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdp
dCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL2NvcHl0by5jIGIvc3JjL2JhY2tlbmQvY29tbWFuZHMv
Y29weXRvLmMKaW5kZXggZjBlMDE0N2M2NjUuLjg1ZDE1MzUzNjQ3IDEwMDY0NAotLS0gYS9zcmMv
YmFja2VuZC9jb21tYW5kcy9jb3B5dG8uYworKysgYi9zcmMvYmFja2VuZC9jb21tYW5kcy9jb3B5
dG8uYwpAQCAtMTAzMyw3ICsxMDMzLDcgQEAgQmVnaW5Db3B5VG8oUGFyc2VTdGF0ZSAqcHN0YXRl
LAogCXsKIAkJY3N0YXRlLT5qc29uX2J1ZiA9IG1ha2VTdHJpbmdJbmZvKCk7CiAKLQkJaWYgKGF0
dG5hbWVsaXN0ICE9IE5JTCAmJiByZWwpCisJCWlmIChyZWwgJiYgbGlzdF9sZW5ndGgoY3N0YXRl
LT5hdHRudW1saXN0KSA8IHR1cERlc2MtPm5hdHRzKQogCQl7CiAJCQlpbnQJCQluYXR0cyA9IGxp
c3RfbGVuZ3RoKGNzdGF0ZS0+YXR0bnVtbGlzdCk7CiAJCQlUdXBsZURlc2MJcmVzdWx0RGVzYzsK
ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ2VuZXJhdGVkX3N0b3JlZC5v
dXQgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF9zdG9yZWQub3V0CmluZGV4
IDQzY2RkZWFjMzczLi40ZDMyOWM2MDk5NCAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9l
eHBlY3RlZC9nZW5lcmF0ZWRfc3RvcmVkLm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVj
dGVkL2dlbmVyYXRlZF9zdG9yZWQub3V0CkBAIC01NDEsNiArNTQxLDEyIEBAIFNFTEVDVCAqIEZS
T00gZ3Rlc3QzIE9SREVSIEJZIGE7CiAgNCB8IDEyCiAoNCByb3dzKQogCistLSBDT1BZIEpTT04g
c2hvdWxkIGV4Y2x1ZGUgZ2VuZXJhdGVkIGNvbHVtbnMsIHNhbWUgYXMgdGV4dC9DU1YKK0NPUFkg
Z3Rlc3QxIFRPIHN0ZG91dCBXSVRIIChGT1JNQVQganNvbik7Cit7ImEiOjF9Cit7ImEiOjJ9Cit7
ImEiOjN9Cit7ImEiOjR9CiAtLSBudWxsIHZhbHVlcwogQ1JFQVRFIFRBQkxFIGd0ZXN0MiAoYSBp
bnQgUFJJTUFSWSBLRVksIGIgaW50IEdFTkVSQVRFRCBBTFdBWVMgQVMgKE5VTEwpIFNUT1JFRCk7
CiBJTlNFUlQgSU5UTyBndGVzdDIgVkFMVUVTICgxKTsKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3Jl
Z3Jlc3MvZXhwZWN0ZWQvZ2VuZXJhdGVkX3ZpcnR1YWwub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9l
eHBlY3RlZC9nZW5lcmF0ZWRfdmlydHVhbC5vdXQKaW5kZXggMjM0MDYxZmExZjcuLmZjNDFjNDgw
ZDQwIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF92aXJ0
dWFsLm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dlbmVyYXRlZF92aXJ0dWFs
Lm91dApAQCAtNTM1LDYgKzUzNSwxMiBAQCBTRUxFQ1QgKiBGUk9NIGd0ZXN0MyBPUkRFUiBCWSBh
OwogIDQgfCAxMgogKDQgcm93cykKIAorLS0gQ09QWSBKU09OIHNob3VsZCBleGNsdWRlIGdlbmVy
YXRlZCBjb2x1bW5zLCBzYW1lIGFzIHRleHQvQ1NWCitDT1BZIGd0ZXN0MSBUTyBzdGRvdXQgV0lU
SCAoRk9STUFUIGpzb24pOworeyJhIjoxfQoreyJhIjoyfQoreyJhIjozfQoreyJhIjo0fQogLS0g
bnVsbCB2YWx1ZXMKIENSRUFURSBUQUJMRSBndGVzdDIgKGEgaW50IFBSSU1BUlkgS0VZLCBiIGlu
dCBHRU5FUkFURUQgQUxXQVlTIEFTIChOVUxMKSBWSVJUVUFMKTsKIElOU0VSVCBJTlRPIGd0ZXN0
MiBWQUxVRVMgKDEpOwpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2VuZXJhdGVk
X3N0b3JlZC5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9nZW5lcmF0ZWRfc3RvcmVkLnNxbApp
bmRleCAyODAwMjFkNzliNy4uMTA2NDgzOWRjZDIgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jl
c3Mvc3FsL2dlbmVyYXRlZF9zdG9yZWQuc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dl
bmVyYXRlZF9zdG9yZWQuc3FsCkBAIC0yMzksNiArMjM5LDkgQEAgQ09QWSBndGVzdDMgKGEsIGIp
IEZST00gc3RkaW47CiAKIFNFTEVDVCAqIEZST00gZ3Rlc3QzIE9SREVSIEJZIGE7CiAKKy0tIENP
UFkgSlNPTiBzaG91bGQgZXhjbHVkZSBnZW5lcmF0ZWQgY29sdW1ucywgc2FtZSBhcyB0ZXh0L0NT
VgorQ09QWSBndGVzdDEgVE8gc3Rkb3V0IFdJVEggKEZPUk1BVCBqc29uKTsKKwogLS0gbnVsbCB2
YWx1ZXMKIENSRUFURSBUQUJMRSBndGVzdDIgKGEgaW50IFBSSU1BUlkgS0VZLCBiIGludCBHRU5F
UkFURUQgQUxXQVlTIEFTIChOVUxMKSBTVE9SRUQpOwogSU5TRVJUIElOVE8gZ3Rlc3QyIFZBTFVF
UyAoMSk7CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9nZW5lcmF0ZWRfdmlydHVh
bC5zcWwgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9nZW5lcmF0ZWRfdmlydHVhbC5zcWwKaW5kZXgg
NGQ5YWQzYzVkY2EuLjliMzI0MTNlM2E5IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3Nx
bC9nZW5lcmF0ZWRfdmlydHVhbC5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2VuZXJh
dGVkX3ZpcnR1YWwuc3FsCkBAIC0yMzksNiArMjM5LDkgQEAgQ09QWSBndGVzdDMgKGEsIGIpIEZS
T00gc3RkaW47CiAKIFNFTEVDVCAqIEZST00gZ3Rlc3QzIE9SREVSIEJZIGE7CiAKKy0tIENPUFkg
SlNPTiBzaG91bGQgZXhjbHVkZSBnZW5lcmF0ZWQgY29sdW1ucywgc2FtZSBhcyB0ZXh0L0NTVgor
Q09QWSBndGVzdDEgVE8gc3Rkb3V0IFdJVEggKEZPUk1BVCBqc29uKTsKKwogLS0gbnVsbCB2YWx1
ZXMKIENSRUFURSBUQUJMRSBndGVzdDIgKGEgaW50IFBSSU1BUlkgS0VZLCBiIGludCBHRU5FUkFU
RUQgQUxXQVlTIEFTIChOVUxMKSBWSVJUVUFMKTsKIElOU0VSVCBJTlRPIGd0ZXN0MiBWQUxVRVMg
KDEpOwotLSAKMi4zNC4xCgo=
--000000000000e34205064f6cad1a--