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 1v1sSt-00DcO8-De for pgsql-general@arkaria.postgresql.org; Thu, 25 Sep 2025 20:21:19 +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 1v1sSq-005sFi-Rx for pgsql-general@arkaria.postgresql.org; Thu, 25 Sep 2025 20:21:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v1sSp-005sDp-TA for pgsql-general@lists.postgresql.org; Thu, 25 Sep 2025 20:21:16 +0000 Received: from fout-a2-smtp.messagingengine.com ([103.168.172.145]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1v1sSj-002QQR-3C for pgsql-general@lists.postgresql.org; Thu, 25 Sep 2025 20:21:15 +0000 Received: from phl-compute-10.internal (phl-compute-10.internal [10.202.2.50]) by mailfout.phl.internal (Postfix) with ESMTP id 37808EC0012; Thu, 25 Sep 2025 16:21:09 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-10.internal (MEProxy); Thu, 25 Sep 2025 16:21:09 -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=fm3; t=1758831669; x=1758918069; bh=5MZr2MWJ8ysoAcBXRiwhl1nlU0Yy2SLVotHnjhO1kGM=; b= ZWEtscjbWQ9ncWtVLm0OhsFfte1Fj6evuchmPuwJOQbbEsjNRfJrvk05N9juFIV1 84+pXuKiWgOJh58D8MIejWU1P07zdieOHNQD+MImBYPTb+AxUfjWKEMlZevBBTpU 0CYI5UfBeWQT3Gn2PbXx/rkcaHiIEQNj3vb/UM9dl+T4EkIyfolShFQE3KJxZaS4 h6OT1V3KEzQj/v0nnNoiLOjKCALuJ0q9DLRzxWBQL6sdqCkQuquX+kZtyajDVuKF ujrxZijHwS/nQULx0Xe6IcnTItPczdRiibQXsPMQGTWBUKa2LIt/iWSoWLTIqNUL lNPLxZJsmJIaS3GAiR8YdQ== 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=fm1; t=1758831669; x=1758918069; bh=5 MZr2MWJ8ysoAcBXRiwhl1nlU0Yy2SLVotHnjhO1kGM=; b=IJ70LfIDJBVGROUat zbFASvehMmJkxQ5hkW+1sNAxnGz4NmPxk2wdMqBOdB7rh5w/axOrBtl4BfOsa95+ VcxfoJsXYnBxunNcDKR8ARrZbA1GSe+dgin3zr0IW3rWAWNpXEUaZ1iqUxXNKVAB MNsdV3SoUhvm09lpkIVXfhyha8gZZd3kDHpftItxoGugb3D7brdNL8+sz/OLzNr+ jr91ShDxQRep/e7/zd5rWMv+HND1VTXHFPV0lGGq71ftieJfe3Dgg01dX3fWBle1 dCnMknX6GgbGY+opz4tWSO19tIDQ01+O4F4cz4vBGcGqB9E3q8oSLlho+3xigDox dTk6A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdeijeegfecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgrnhcu mfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqne cuggftrfgrthhtvghrnhepiedvhfeiheehgeeuieeljeeitedtjeehudegfeelkedvleek hedtgfeiffefkedunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilh hfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomhdpnhgspghr tghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepsghrhihsrgihvg hrsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhi shhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 25 Sep 2025 16:21:08 -0400 (EDT) Message-ID: Date: Thu, 25 Sep 2025 13:21:07 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Additional options for COPY from To: Bryan Sayer , "pgsql-general@lists.postgresql.org" References: <80c44b4d-1185-478b-939c-62e0d4377106@gmail.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <80c44b4d-1185-478b-939c-62e0d4377106@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/25/25 11:49, Bryan Sayer wrote: > Hi, > > I'm not sure if this is the best list to ask this (and I am very new to > PostgreSQL) but I think more options are needed in the COPY from > command, in order to better deal with exceptions. By exceptions I mean > data not consistent with the format, empty rows, extra delimiters at the > end of rows, etc. What do you mean by '... deal with exceptions.'? > *Bryan Sayer* > Retired Demographer/Statistician > /In a world in which you can be anything, *be kind*/ -- Adrian Klaver adrian.klaver@aklaver.com