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 1uuBgZ-004Ei1-MU for pgsql-admin@arkaria.postgresql.org; Thu, 04 Sep 2025 15:15:40 +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 1uuBgX-00Gztd-J2 for pgsql-admin@arkaria.postgresql.org; Thu, 04 Sep 2025 15:15:38 +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 1uuBgX-00GzsJ-5u for pgsql-admin@lists.postgresql.org; Thu, 04 Sep 2025 15:15:37 +0000 Received: from mail-ej1-x636.google.com ([2a00:1450:4864:20::636]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uuBgS-000YHt-32 for pgsql-admin@lists.postgresql.org; Thu, 04 Sep 2025 15:15:35 +0000 Received: by mail-ej1-x636.google.com with SMTP id a640c23a62f3a-aff0775410eso276699966b.0 for ; Thu, 04 Sep 2025 08:15:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1756998931; x=1757603731; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=o7WSMfh6kjQoEgg7JzhFuet2mDjfZJ69Cy1ZEUCpXSc=; b=LjkTxeC6vV79maScTTSMgN+UHb0R4rDVWyO0avjK6SYyLblL0f8gA3PRmKf/a1CBg8 eFupkXV7eQ4sDy7jMwaz98hDvtm/W4Z5RVcEPAnEZ57KbU6KKopWfQawrEX9WjTC2Wq6 0oKW8bVF/MqYX/GNl2H6C5nHqgjpt1ZfN2qO9KwrB58iCDYBzzVnFU7gvqvI4yZ+NTJp GNQ+8wobN4RN+w3riCl9T74HV7srcaEgiycU7MtXPBV6P7LmWyDUffB5X0wBnCGWqtmN aINXmoTss+alR0R2ZAYgOZ+Li0PwZFON17OBEKhxgH5XFR56nBXfOK6jqg+jYv4Pz6zV BPRw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1756998932; x=1757603732; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=o7WSMfh6kjQoEgg7JzhFuet2mDjfZJ69Cy1ZEUCpXSc=; b=uwkhy2eTO4QWcybkWgV038DmVZmf5cgGpfFKr8ZbqCKHRvqvc7BoskuuuOnkGY4i6L U79jXAlbsKcISlxdYfc9400PkTkVCTcQxkb+iCjL2WW2wUiWyqg2eX85+l+1n6KPppYt 2hLBUKVkZ0v43s9X8k4FyJKXOEa6vzX0FEMHNIRSWtQ9QjcwFsUQX5laftJAdvykm+Z/ N8TtLWNucV0TNzaYXup+grFfGA4f85uF5/YTChpA7cPahX7FS/mVRL6UgikkLYtygPhn MuZFyK9AbPDIlACbQN+3B1V3vzL9BWWg9KovIpi9J6t08UyGt/Y49tRdYOnKvETXyrie b0UQ== X-Gm-Message-State: AOJu0YzMZZF5ECnN0++Lb4RUUEdscVDImerC8LSS9bDzpvYkfd/RkI7m DSNasdkDHdoMyNPzDtca9zCCzDV8CFO7GswY8vIo8DlUFLF0cwEo1V2r3Gddu56sfPs= X-Gm-Gg: ASbGncupa6QlOWNYLP2NwvpNoBYDJ95FTX+7Uz6WYfhEN3Dhq0u78QWxXm2ncFRSTOK S/oncuywHz8dJ/Xtg5kmGgz1Go/mL2zyZ+WRusZTXcm2zxJzSlxVPr3qb/emQvxP3ksdIj6+3Lb 3sOfx3Qr2EJY9+sxYnhn1p3QA7XLPtIf1ePmpByf6P3lN/SiBW7V6keI1/1LudGdV2wwMtUwvFW tahIuhUDo/eNvaiGS9iSPpmmHW52o2cH7iLgJGVeDoZ7icLHpJ6mSx3mxyspWb1xsP51nR5yfQx r/NVG6ng3Dwwys736v87k2a4tClT2tDO17Nq+p2DxBtbTvFgV+CO7UWHnuX5KpXK6AToyLPY65M hJP8N3TfLYyktsBpGrOn3YcTR6RpodQUBuxgM1a64PT/Jg+KvQsXebMx6rAA= X-Google-Smtp-Source: AGHT+IF8t9/81xu2tCyx3yqrk4r4mQhstX+9OpAYicxDGro9wtIWVNildj85srs4+hlM1nuMCxBxyQ== X-Received: by 2002:a17:906:37da:b0:b04:7eba:1b55 with SMTP id a640c23a62f3a-b04931013c1mr1078066b.19.1756998931531; Thu, 04 Sep 2025 08:15:31 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([41.66.96.30]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b0409bf055esm1317690666b.85.2025.09.04.08.15.30 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 04 Sep 2025 08:15:31 -0700 (PDT) Message-ID: <43da713956af87a859ac7ef1b9ac80f11b8ded81.camel@cybertec.at> Subject: Re: Escaping special characters - \r when doing COPY CSV From: Laurenz Albe To: Edwin UY Cc: Pgsql-admin Date: Thu, 04 Sep 2025 17:15:30 +0200 In-Reply-To: References: <8ec53dc7d4508410124a5a6d1442840aa90a8f0c.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-09-04 at 21:39 +1200, Edwin UY wrote: > Thanks Laurenz, any trick up your sleeves that will work for a select * i= nstead of having to do it for individual columns=C2=A0 I would have told you if I had. Yours, Laurenz Albe