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 1uaCkH-0012L1-P1 for pgsql-general@arkaria.postgresql.org; Fri, 11 Jul 2025 12:20:54 +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 1uaCkF-004Y3P-SF for pgsql-general@arkaria.postgresql.org; Fri, 11 Jul 2025 12:20:52 +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 1uaCkF-004Y3G-10 for pgsql-general@lists.postgresql.org; Fri, 11 Jul 2025 12:20:52 +0000 Received: from m16.mail.126.com ([117.135.210.7]) by magus.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uaCk9-0071Hd-2T for pgsql-general@lists.postgresql.org; Fri, 11 Jul 2025 12:20:50 +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=KCWnzdDW+xXivWZeJicsJi24B38v1pvSDBccIOl5kLU=; b=A Pt0H+V44EEADFzzm0kYwBKB282hLr3fjT82mALol64zb17L0oLftTmcVx6Am/d5z wapPKY1w4pVs+RyoGC/ZsgSsip9Arzh2RZWSQXne9Yz+Eqlo91HKjTKwmNbEEMzs nbsHg3JIQaYvAl2LH0DLGsUlUYh/XtDq8DJ8CGrBDQ= Received: from gzhcoder$126.com ( [211.144.19.63] ) by ajax-webmail-wmsvr-41-105 (Coremail) ; Fri, 11 Jul 2025 20:20:38 +0800 (CST) X-Originating-IP: [211.144.19.63] Date: Fri, 11 Jul 2025 20:20:38 +0800 (CST) From: gzh To: pgsql-general@lists.postgresql.org Subject: 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 X-NTES-SC: AL_Qu2eAP6YuUwo7iicbekfmUwUgOY+Uce4vfQn1YVeOpl9jDnj2i8FQGRlBGrx/dymLAurrT6xcjlFyfR/W61TYaM28bqdVJ6FsyG3dTgbyfbMvw== Content-Type: multipart/alternative; boundary="----=_Part_134475_219970490.1752236438851" MIME-Version: 1.0 Message-ID: <43b9fb8c.8b5c.197f96e3544.Coremail.gzhcoder@126.com> X-Coremail-Locale: zh_CN X-CM-TRANSID:aSkvCgD3X2iWAXFokHgFAA--.38930W X-CM-SenderInfo: 5j2ku0xghuqiyswou0bp/1tbi3BR+WWhkydoiTwADse X-Coremail-Antispam: 1U5529EdanIXcx71UUUUU7vcSsGvfC2KfnxnUU== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_134475_219970490.1752236438851 Content-Type: text/plain; charset=GBK Content-Transfer-Encoding: base64 RGVhciwKCgpJIGFtIGVuY291bnRlcmluZyBhbiBpc3N1ZSB3aXRoIHRoZSBDT1BZIGNvbW1hbmQg aW4gUG9zdGdyZVNRTCByZWdhcmRpbmcgdGhlIGhhbmRsaW5nIG9mIGxpbmUgYnJlYWtzIGluIGRh dGEgZmllbGRzLiBNeSBQb3N0Z3JlU1FMIGluc3RhbmNlIGlzIGluc3RhbGxlZCBvbiBhIExpbnV4 IHN5c3RlbS4KCgpXaGVuIEkgdXNlIHRoZSBDT1BZIGNvbW1hbmQgdG8gZXhwb3J0IGRhdGEgdG8g YSBDU1YgZmlsZSBhbmQgdGhlbiBpbXBvcnQgdGhlIHNhbWUgQ1NWIGZpbGUgYmFjayBpbnRvIHRo ZSBkYXRhYmFzZSwgYWxsIGNhcnJpYWdlIHJldHVybiBjaGFyYWN0ZXJzIChDUikgaW4gdGhlIGZp ZWxkcyBhcmUgYXV0b21hdGljYWxseSBjb252ZXJ0ZWQgdG8gbGluZSBmZWVkIGNoYXJhY3RlcnMg KExGKS4gRm9yIGV4YW1wbGU6CgoKRmllbGQgY29udGVudCBiZWZvcmUgaW1wb3J0OiAqKiogKENS KSAqKioKRmllbGQgY29udGVudCBhZnRlciBpbXBvcnQ6ICoqKiAoTEYpICoqKgpJIHdvdWxkIGxp a2UgdG8ga25vdyBpZiB0aGVyZSBpcyBhIHdheSB0byB1c2UgdGhlIENPUFkgY29tbWFuZCB3aGls ZSBwcmVzZXJ2aW5nIHRoZSBvcmlnaW5hbCBsaW5lIGJyZWFrcyAoQ1IpIGluIHRoZSBkYXRhIGZp ZWxkcyBkdXJpbmcgaW1wb3J0LgoKClRoYW5rIHlvdSBmb3IgeW91ciBhc3Npc3RhbmNlLgoKCkJl c3QgcmVnYXJkcywKZ3po ------=_Part_134475_219970490.1752236438851 Content-Type: text/html; charset=GBK Content-Transfer-Encoding: base64 PGRpdiBkYXRhLW50ZXM9Im50ZXNfbWFpbF9ib2R5X3Jvb3QiIHN0eWxlPSJsaW5lLWhlaWdodDox Ljc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbCI+PGRpdj5E ZWFyLDwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+SSBhbSBlbmNvdW50ZXJpbmcgYW4gaXNzdWUg d2l0aCB0aGUgQ09QWSBjb21tYW5kIGluIFBvc3RncmVTUUwgcmVnYXJkaW5nIHRoZSBoYW5kbGlu ZyBvZiBsaW5lIGJyZWFrcyBpbiBkYXRhIGZpZWxkcy4gTXkgUG9zdGdyZVNRTCBpbnN0YW5jZSBp cyBpbnN0YWxsZWQgb24gYSBMaW51eCBzeXN0ZW0uPC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5X aGVuIEkgdXNlIHRoZSBDT1BZIGNvbW1hbmQgdG8gZXhwb3J0IGRhdGEgdG8gYSBDU1YgZmlsZSBh bmQgdGhlbiBpbXBvcnQgdGhlIHNhbWUgQ1NWIGZpbGUgYmFjayBpbnRvIHRoZSBkYXRhYmFzZSwg YWxsIGNhcnJpYWdlIHJldHVybiBjaGFyYWN0ZXJzIChDUikgaW4gdGhlIGZpZWxkcyBhcmUgYXV0 b21hdGljYWxseSBjb252ZXJ0ZWQgdG8gbGluZSBmZWVkIGNoYXJhY3RlcnMgKExGKS4gRm9yIGV4 YW1wbGU6PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5GaWVsZCBjb250ZW50IGJlZm9yZSBpbXBv cnQ6ICoqKiAoQ1IpICoqKjwvZGl2PjxkaXY+RmllbGQgY29udGVudCBhZnRlciBpbXBvcnQ6ICoq KiAoTEYpICoqKjwvZGl2PjxkaXY+SSB3b3VsZCBsaWtlIHRvIGtub3cgaWYgdGhlcmUgaXMgYSB3 YXkgdG8gdXNlIHRoZSBDT1BZIGNvbW1hbmQgd2hpbGUgcHJlc2VydmluZyB0aGUgb3JpZ2luYWwg bGluZSBicmVha3MgKENSKSBpbiB0aGUgZGF0YSBmaWVsZHMgZHVyaW5nIGltcG9ydC48L2Rpdj48 ZGl2Pjxicj48L2Rpdj48ZGl2PlRoYW5rIHlvdSBmb3IgeW91ciBhc3Npc3RhbmNlLjwvZGl2Pjxk aXY+PGJyPjwvZGl2PjxkaXY+QmVzdCByZWdhcmRzLDwvZGl2PjxkaXY+Z3poPC9kaXY+PC9kaXY+ ------=_Part_134475_219970490.1752236438851--