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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uaFSH-002Qvf-US
	for pgsql-general@arkaria.postgresql.org; Fri, 11 Jul 2025 15:14:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1uaFSG-005iG9-2o
	for pgsql-general@arkaria.postgresql.org; Fri, 11 Jul 2025 15:14:28 +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 <adrian.klaver@aklaver.com>)
	id 1uaFSF-005iG1-7k
	for pgsql-general@lists.postgresql.org; Fri, 11 Jul 2025 15:14:28 +0000
Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1uaFSC-0072p4-2L
	for pgsql-general@lists.postgresql.org;
	Fri, 11 Jul 2025 15:14:27 +0000
Received: from phl-compute-02.internal (phl-compute-02.phl.internal [10.202.2.42])
	by mailfhigh.phl.internal (Postfix) with ESMTP id 5D87314002ED;
	Fri, 11 Jul 2025 11:14:22 -0400 (EDT)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-02.internal (MEProxy); Fri, 11 Jul 2025 11:14:22 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding:content-type:content-type:date:date
	:from:from:in-reply-to:in-reply-to:message-id:mime-version
	:references:reply-to:subject:subject:to:to; s=fm1; t=1752246862;
	 x=1752333262; bh=Ah0yU5+2zvYS8Y2md3dzaASzWqbBDQy4+FgXz9IBmXg=; b=
	g13Yy1s46NjfAcQKw7++b790ifIvmSK+dNjeks7TBE8bvjA0jdUD4WDo/0ad3sOk
	sd4gA0jVM+Bcw1NffGR6nBgS+Hj0Spegp+nV2ulmoUQcTe0A2AF7lB490zLpqt6c
	i3CMWSYJv2tCLree98WVhQ06Lbaa8zLIpGdVLqY+snRc62RvvKSHIYLZy6U3GTbI
	Cv+Oj5j580xvixblqEDf+7ALuQ2FVCrVwKVjmwvkWSrpzwSeHkKFjyIGK3ztF4hI
	UhHJ94aQnRF5fZUMJdeFNa1jhlaIB482KIJBaIKxnrMTUx3ahrsjWw+I+rQcQVPE
	x2o/mA93x8OGYd8vvB7paQ==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=cc:content-transfer-encoding:content-type
	:content-type:date:date:feedback-id:feedback-id:from:from
	:in-reply-to:in-reply-to:message-id:mime-version:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-sender
	:x-me-sender:x-sasl-enc; s=fm2; t=1752246862; x=1752333262; bh=A
	h0yU5+2zvYS8Y2md3dzaASzWqbBDQy4+FgXz9IBmXg=; b=hcDgF8U+1+0vLlNWZ
	HsssrgmTavPvNgJ4RP/ZuqUcCLPw/JKXDUJCNWjDAVwrmMuQjUHnORPkLwbKQIlh
	OHWjozF+Q3J+Smv3slmkUrA+tFoQbcS/kiIb89tAYxm4xbdz6uo7N43cp4Qg52Iy
	hnkeTGFWhYPRXIGIXf6T4osxc5dBw2IIdxrt2MkawKtJmK0FAUk1AgwEBMNJuDOI
	N6RFzW/L7nm9kfPSa+wGq2eoJklF3hDZlKz7TolnunETqLWSxo/HF/Tur/Y9bIin
	Nw4J1YuYu2vGp/SiGlDqiaadI1OgDCs/ne8a2hWqxYLulnrnAi01gqe4y/fHdLl2
	gG3Xw==
X-ME-Sender: <xms:TipxaOxM0uSQfoEIs_80i63kPr-nGgXM-9QiTlhIF0pDW_UooYvQRg>
    <xme:TipxaKe-fyTkIhVPq0vcZ9Fk8nu4eZ_reHW747S8TBHVC3nE3YVQucMjG-42qgyFn
    JJOn5Q8V46wcIg>
X-ME-Received: <xmr:TipxaCKAfAu_FrYpfTvaBi57_x8j41DvdvLDrnhWkMrSTvAnusCATko-l-qjYkoOKRQgRViwfS7K-ZLTbHurmlfUUYtQ_mtL>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdegfeeihecutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr
    ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug
    hrpefkffggfgfuvfhfhfgjtgfgsehtkeertddtvdejnecuhfhrohhmpeetughrihgrnhcu
    mfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqne
    cuggftrfgrthhtvghrnhepffelgeeifefgveduhedthfekuedtffejveegffegjeevtdeh
    gfduieetfeehjeehnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh
    hfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghr
    tghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtoheprhhonhhljhhohh
    hnshhonhhjrhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghr
    rghlsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:TipxaDGYP0QyGMYo3IF6j2X2aBlngDDuC3rDYRWZ2YaSN8uAAfULig>
    <xmx:TipxaEq-k5o7vz3P7coVA6OjK6_HKQ306TCAZRghN3y-BNwZQpMJZA>
    <xmx:TipxaEQ0qwEr9VQsPvl37BUuHKmEKSRMbstLsmIEEMMsHYxlhfAOqw>
    <xmx:TipxaJNQXF-Rwr-0OiNqvQjbUiOAqLEnN4Yje6_069bcJALlMKH9eg>
    <xmx:TipxaKuTZAl1iCQb99Xu4zTAw4wgik8_TMUntKdQjg7owmgfdjJgsV1J>
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri,
 11 Jul 2025 11:14:21 -0400 (EDT)
Message-ID: <7a27981e-b55c-47c6-8053-d9369506ccf5@aklaver.com>
Date: Fri, 11 Jul 2025 08:14:21 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Question Regarding COPY Command Handling of Line Breaks in
 PostgreSQL
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <43b9fb8c.8b5c.197f96e3544.Coremail.gzhcoder@126.com>
 <CANzqJaB24YUU-toCxGWVUym2Fas2QATYhuZCM3M0ZHfkmcFMbw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaB24YUU-toCxGWVUym2Fas2QATYhuZCM3M0ZHfkmcFMbw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/7a27981e-b55c-47c6-8053-d9369506ccf5%40aklaver.com>
Precedence: bulk

On 7/11/25 06:07, Ron Johnson wrote:
> On Fri, Jul 11, 2025 at 8:20 AM gzh <gzhcoder@126.com 
> <mailto:gzhcoder@126.com>> wrote:

> What PG version?
> What's the full command (including both shell and SQL commands)?

Also provide a sample of the original exported data and a sample of the 
data after it is imported.

-- 
Adrian Klaver
adrian.klaver@aklaver.com