Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uc1mx-0088RO-Bq for pgsql-general@arkaria.postgresql.org; Wed, 16 Jul 2025 13:03:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uc1mu-00A7o8-9a for pgsql-general@arkaria.postgresql.org; Wed, 16 Jul 2025 13:03:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uc1mt-00A7o0-D8 for pgsql-general@lists.postgresql.org; Wed, 16 Jul 2025 13:03:08 +0000 Received: from m16.mail.126.com ([117.135.210.8]) by magus.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uc1mm-008450-0c for pgsql-general@lists.postgresql.org; Wed, 16 Jul 2025 13:03:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=126.com; s=s110527; h=Date:From:To:Subject:Content-Type:MIME-Version: Message-ID; bh=iKvK1Sq/kxoxrKMjNrF2HypsCHau+5Fv9VC7Ul+lews=; b=U se/TsnZPVO0/WVwac2tZL172gzXHvLz46X+sNHuFhocbQkBHvGznX+JAYi3F1a1H nXw+vuLCY207YM0ERz1QT51nzoHcWrf+ACcBEDAo7UB00C/vSn9392qwjEzAES+b xr5X7MdfZ+Gbt3dvs41j7NPTapqwBdXpo3mlau6gh4= Received: from gzhcoder$126.com ( [211.144.19.63] ) by ajax-webmail-wmsvr-41-104 (Coremail) ; Wed, 16 Jul 2025 21:02:52 +0800 (CST) X-Originating-IP: [211.144.19.63] Date: Wed, 16 Jul 2025 21:02:52 +0800 (CST) From: gzh To: pgsql-general@lists.postgresql.org Subject: Re:Question Regarding COPY Command Handling of Line Breaks in PostgreSQL X-Priority: 3 X-Mailer: Coremail Webmail Server Version XT5.0.14 build 20250519(9504565a) Copyright (c) 2002-2025 www.mailtech.cn 126com In-Reply-To: <43b9fb8c.8b5c.197f96e3544.Coremail.gzhcoder@126.com> References: <43b9fb8c.8b5c.197f96e3544.Coremail.gzhcoder@126.com> X-NTES-SC: AL_Qu2eAPqcv0Es5CSRbOkfmUwUgOY+Uce4vfQn1YVeOpl9jDjj+h0OTVVzOVzfwf+FASKIjyineRxczN9DTa9geqUUUCB31iaqnJFZDCGInxo8Vw== Content-Type: multipart/alternative; boundary="----=_Part_135963_1472352782.1752670972504" MIME-Version: 1.0 Message-ID: <29948df8.8c95.1981354aa58.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID:aCkvCgD31z38ondo4mcIAA--.54103W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi5QqLWWh2PAVHbAACsz X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_135963_1472352782.1752670972504 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 CgoKVGhlIGNhdXNlIGhhcyBiZWVuIGlkZW50aWZpZWQuIEluIG15IFZCIHByb2dyYW0sIEkgd2Fz IHVzaW5nIHRoZSBDT1BZIGNvbW1hbmQuIAoKVG8gcHJldmVudCBtZW1vcnkgaXNzdWVzIHdpdGgg bGFyZ2UgZmlsZXMsIEkgY2hhbmdlZCB0aGUgZmlsZSByZWFkaW5nIG1ldGhvZCBmcm9tIHJlYWRp bmcgdGhlIGVudGlyZSBmaWxlIGF0IG9uY2UgdG8gcmVhZGluZyBpdCBsaW5lIGJ5IGxpbmUsIGFz IHNob3duIGJlbG93LiAKCkhvd2V2ZXIsIHRoaXMgY2F1c2VkIGxpbmUgYnJlYWtzIHdpdGhpbiB0 aGUgZGF0YSB0byBiZSBsb3N0LiBUaGlzIGlzIG5vdCBhbiBpc3N1ZSB3aXRoIHRoZSBDT1BZIGNv bW1hbmQgaXRzZWxmLiAKCkkgdGVzdGVkIHJlYWRpbmcgdGhlIGVudGlyZSBmaWxlIGF0IG9uY2Us IGFuZCBpdCB3b3JrZWQgd2l0aG91dCBhbnkgcHJvYmxlbXMuIE15IGFwb2xvZ2llcyBmb3IgdGhl IGNvbmZ1c2lvbi4KCgoKClJlYWRpbmcgdGhlIGVudGlyZSBmaWxlIGF0IG9uY2U6CgoKCgpVc2lu ZyByZWFkZXIgQXMgTmV3IFN0cmVhbVJlYWRlcihpbnB1dEZpbGUsIFN5c3RlbS5UZXh0LkVuY29k aW5nLlVURjgpCgogICAgVXNpbmcgY29weUluID0gY29ubi5CZWdpblRleHRJbXBvcnQoIkNPUFkg U2NoZW1hLnRhYmxlTmFtZSBGUk9NIFNURElOIFdJVEggQ1NWIEhFQURFUiIpCgogICAgICAgIGNv cHlJbi5Xcml0ZShyZWFkZXIuUmVhZFRvRW5kKCkpCgogICAgRW5kIFVzaW5nCgpFbmQgVXNpbmcK CgoKClJlYWRpbmcgdGhlIGZpbGUgbGluZSBieSBsaW5lOgoKCgoKVXNpbmcgcmVhZGVyIEFzIE5l dyBTdHJlYW1SZWFkZXIoaW5wdXRGaWxlLCBTeXN0ZW0uVGV4dC5FbmNvZGluZy5VVEY4KQoKICAg IFVzaW5nIGNvcHlJbiA9IGNvbm4uQmVnaW5UZXh0SW1wb3J0KCJDT1BZIFNjaGVtYS50YWJsZU5h bWUgRlJPTSBTVERJTiBXSVRIIENTViBIRUFERVIiKQoKICAgICAgICBXaGlsZSBOb3QgcmVhZGVy LkVuZE9mU3RyZWFtCgogICAgICAgICAgICBEaW0gbGluZSBBcyBTdHJpbmcgPSByZWFkZXIuUmVh ZExpbmUoKQoKICAgICAgICAgICAgY29weUluLldyaXRlKGxpbmUgJiB2YkxmKQoKICAgICAgICBF bmQgV2hpbGUKCiAgICBFbmQgVXNpbmcKCkVuZCBVc2luZwoKCgoKCgoKCgoKCgoKQXQgMjAyNS0w Ny0xMSAyMDoyMDozOCwgImd6aCIgPGd6aGNvZGVyQDEyNi5jb20+IHdyb3RlOgoKRGVhciwKCgpJ IGFtIGVuY291bnRlcmluZyBhbiBpc3N1ZSB3aXRoIHRoZSBDT1BZIGNvbW1hbmQgaW4gUG9zdGdy ZVNRTCByZWdhcmRpbmcgdGhlIGhhbmRsaW5nIG9mIGxpbmUgYnJlYWtzIGluIGRhdGEgZmllbGRz LiBNeSBQb3N0Z3JlU1FMIGluc3RhbmNlIGlzIGluc3RhbGxlZCBvbiBhIExpbnV4IHN5c3RlbS4K CgpXaGVuIEkgdXNlIHRoZSBDT1BZIGNvbW1hbmQgdG8gZXhwb3J0IGRhdGEgdG8gYSBDU1YgZmls ZSBhbmQgdGhlbiBpbXBvcnQgdGhlIHNhbWUgQ1NWIGZpbGUgYmFjayBpbnRvIHRoZSBkYXRhYmFz ZSwgYWxsIGNhcnJpYWdlIHJldHVybiBjaGFyYWN0ZXJzIChDUikgaW4gdGhlIGZpZWxkcyBhcmUg YXV0b21hdGljYWxseSBjb252ZXJ0ZWQgdG8gbGluZSBmZWVkIGNoYXJhY3RlcnMgKExGKS4gRm9y IGV4YW1wbGU6CgoKRmllbGQgY29udGVudCBiZWZvcmUgaW1wb3J0OiAqKiogKENSKSAqKioKRmll bGQgY29udGVudCBhZnRlciBpbXBvcnQ6ICoqKiAoTEYpICoqKgpJIHdvdWxkIGxpa2UgdG8ga25v dyBpZiB0aGVyZSBpcyBhIHdheSB0byB1c2UgdGhlIENPUFkgY29tbWFuZCB3aGlsZSBwcmVzZXJ2 aW5nIHRoZSBvcmlnaW5hbCBsaW5lIGJyZWFrcyAoQ1IpIGluIHRoZSBkYXRhIGZpZWxkcyBkdXJp bmcgaW1wb3J0LgoKClRoYW5rIHlvdSBmb3IgeW91ciBhc3Npc3RhbmNlLgoKCkJlc3QgcmVnYXJk cywKZ3po ------=_Part_135963_1472352782.1752670972504 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdiBp ZD0ic3BuRWRpdG9yQ29udGVudCI+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxicj48L3A+PHAgc3R5 bGU9Im1hcmdpbjogMDsiPlRoZSBjYXVzZSBoYXMgYmVlbiBpZGVudGlmaWVkLiBJbiBteSBWQiBw cm9ncmFtLCBJIHdhcyB1c2luZyB0aGUgQ09QWSBjb21tYW5kLiZuYnNwOzwvcD48cCBzdHlsZT0i bWFyZ2luOiAwOyI+VG8gcHJldmVudCBtZW1vcnkgaXNzdWVzIHdpdGggbGFyZ2UgZmlsZXMsIEkg Y2hhbmdlZCB0aGUgZmlsZSByZWFkaW5nIG1ldGhvZCBmcm9tIHJlYWRpbmcgdGhlIGVudGlyZSBm aWxlIGF0IG9uY2UgdG8gcmVhZGluZyBpdCBsaW5lIGJ5IGxpbmUsIGFzIHNob3duIGJlbG93LiZu YnNwOzwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+SG93ZXZlciwgdGhpcyBjYXVzZWQgbGluZSBi cmVha3Mgd2l0aGluIHRoZSBkYXRhIHRvIGJlIGxvc3QuIFRoaXMgaXMgbm90IGFuIGlzc3VlIHdp dGggdGhlIENPUFkgY29tbWFuZCBpdHNlbGYuJm5ic3A7PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7 Ij5JIHRlc3RlZCByZWFkaW5nIHRoZSBlbnRpcmUgZmlsZSBhdCBvbmNlLCBhbmQgaXQgd29ya2Vk IHdpdGhvdXQgYW55IHByb2JsZW1zLiBNeSBhcG9sb2dpZXMgZm9yIHRoZSBjb25mdXNpb24uPC9w PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5SZWFk aW5nIHRoZSBlbnRpcmUgZmlsZSBhdCBvbmNlOjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJy PjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+VXNpbmcgcmVhZGVyIEFzIE5ldyBTdHJlYW1SZWFk ZXIoaW5wdXRGaWxlLCBTeXN0ZW0uVGV4dC5FbmNvZGluZy5VVEY4KTwvcD48cCBzdHlsZT0ibWFy Z2luOiAwOyI+Jm5ic3A7ICZuYnNwOyBVc2luZyBjb3B5SW4gPSBjb25uLkJlZ2luVGV4dEltcG9y dCgiQ09QWSBTY2hlbWEudGFibGVOYW1lIEZST00gU1RESU4gV0lUSCBDU1YgSEVBREVSIik8L3A+ PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBjb3B5SW4u V3JpdGUocmVhZGVyLlJlYWRUb0VuZCgpKTwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+Jm5ic3A7 ICZuYnNwOyBFbmQgVXNpbmc8L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPkVuZCBVc2luZzwvcD48 cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+UmVhZGlu ZyB0aGUgZmlsZSBsaW5lIGJ5IGxpbmU6PC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij48YnI+PC9w PjxwIHN0eWxlPSJtYXJnaW46IDA7Ij5Vc2luZyByZWFkZXIgQXMgTmV3IFN0cmVhbVJlYWRlcihp bnB1dEZpbGUsIFN5c3RlbS5UZXh0LkVuY29kaW5nLlVURjgpPC9wPjxwIHN0eWxlPSJtYXJnaW46 IDA7Ij4mbmJzcDsgJm5ic3A7IFVzaW5nIGNvcHlJbiA9IGNvbm4uQmVnaW5UZXh0SW1wb3J0KCJD T1BZIFNjaGVtYS50YWJsZU5hbWUgRlJPTSBTVERJTiBXSVRIIENTViBIRUFERVIiKTwvcD48cCBz dHlsZT0ibWFyZ2luOiAwOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IFdoaWxlIE5vdCBy ZWFkZXIuRW5kT2ZTdHJlYW08L3A+PHAgc3R5bGU9Im1hcmdpbjogMDsiPiZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IERpbSBsaW5lIEFzIFN0cmluZyA9IHJlYWRlci5S ZWFkTGluZSgpPC9wPjxwIHN0eWxlPSJtYXJnaW46IDA7Ij4mbmJzcDsgJm5ic3A7ICZuYnNwOyAm bmJzcDsgJm5ic3A7ICZuYnNwOyBjb3B5SW4uV3JpdGUobGluZSAmYW1wOyB2YkxmKTwvcD48cCBz dHlsZT0ibWFyZ2luOiAwOyI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7IEVuZCBXaGlsZTwv cD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+Jm5ic3A7ICZuYnNwOyBFbmQgVXNpbmc8L3A+PHAgc3R5 bGU9Im1hcmdpbjogMDsiPkVuZCBVc2luZzwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwv cD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJyPjwvcD48cCBzdHlsZT0ibWFyZ2luOiAwOyI+PGJy PjwvcD48L2Rpdj48ZGl2IHN0eWxlPSJwb3NpdGlvbjpyZWxhdGl2ZTt6b29tOjEiPjwvZGl2Pjxk aXYgaWQ9ImRpdk5ldGVhc2VNYWlsQ2FyZCI+PC9kaXY+PHAgc3R5bGU9Im1hcmdpbjogMDsiPjxi cj48L3A+PHA+QXQgMjAyNS0wNy0xMSAyMDoyMDozOCwgImd6aCIgJmx0O2d6aGNvZGVyQDEyNi5j b20mZ3Q7IHdyb3RlOjwvcD48YmxvY2txdW90ZSBpZD0iaXNSZXBseUNvbnRlbnQiIHN0eWxlPSJQ QURESU5HLUxFRlQ6IDFleDsgTUFSR0lOOiAwcHggMHB4IDBweCAwLjhleDsgQk9SREVSLUxFRlQ6 ICNjY2MgMXB4IHNvbGlkIj48ZGl2IGRhdGEtbnRlcz0ibnRlc19tYWlsX2JvZHlfcm9vdCIgc3R5 bGU9ImxpbmUtaGVpZ2h0OjEuNztjb2xvcjojMDAwMDAwO2ZvbnQtc2l6ZToxNHB4O2ZvbnQtZmFt aWx5OkFyaWFsIj48ZGl2PkRlYXIsPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5JIGFtIGVuY291 bnRlcmluZyBhbiBpc3N1ZSB3aXRoIHRoZSBDT1BZIGNvbW1hbmQgaW4gUG9zdGdyZVNRTCByZWdh cmRpbmcgdGhlIGhhbmRsaW5nIG9mIGxpbmUgYnJlYWtzIGluIGRhdGEgZmllbGRzLiBNeSBQb3N0 Z3JlU1FMIGluc3RhbmNlIGlzIGluc3RhbGxlZCBvbiBhIExpbnV4IHN5c3RlbS48L2Rpdj48ZGl2 Pjxicj48L2Rpdj48ZGl2PldoZW4gSSB1c2UgdGhlIENPUFkgY29tbWFuZCB0byBleHBvcnQgZGF0 YSB0byBhIENTViBmaWxlIGFuZCB0aGVuIGltcG9ydCB0aGUgc2FtZSBDU1YgZmlsZSBiYWNrIGlu dG8gdGhlIGRhdGFiYXNlLCBhbGwgY2FycmlhZ2UgcmV0dXJuIGNoYXJhY3RlcnMgKENSKSBpbiB0 aGUgZmllbGRzIGFyZSBhdXRvbWF0aWNhbGx5IGNvbnZlcnRlZCB0byBsaW5lIGZlZWQgY2hhcmFj dGVycyAoTEYpLiBGb3IgZXhhbXBsZTo8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PkZpZWxkIGNv bnRlbnQgYmVmb3JlIGltcG9ydDogKioqIChDUikgKioqPC9kaXY+PGRpdj5GaWVsZCBjb250ZW50 IGFmdGVyIGltcG9ydDogKioqIChMRikgKioqPC9kaXY+PGRpdj5JIHdvdWxkIGxpa2UgdG8ga25v dyBpZiB0aGVyZSBpcyBhIHdheSB0byB1c2UgdGhlIENPUFkgY29tbWFuZCB3aGlsZSBwcmVzZXJ2 aW5nIHRoZSBvcmlnaW5hbCBsaW5lIGJyZWFrcyAoQ1IpIGluIHRoZSBkYXRhIGZpZWxkcyBkdXJp bmcgaW1wb3J0LjwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+VGhhbmsgeW91IGZvciB5b3VyIGFz c2lzdGFuY2UuPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5CZXN0IHJlZ2FyZHMsPC9kaXY+PGRp dj5nemg8L2Rpdj48L2Rpdj48L2Jsb2NrcXVvdGU+PC9kaXY+ ------=_Part_135963_1472352782.1752670972504--