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 1sRWzK-00G9wP-2D for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 13:04:02 +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 1sRWzI-00501x-Nf for pgsql-general@arkaria.postgresql.org; Wed, 10 Jul 2024 13:04:00 +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 1sRWzI-00501p-D8 for pgsql-general@lists.postgresql.org; Wed, 10 Jul 2024 13:04:00 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sRWzF-001NES-PF for pgsql-general@lists.postgresql.org; Wed, 10 Jul 2024 13:03:59 +0000 Received: by mail-pj1-x102b.google.com with SMTP id 98e67ed59e1d1-2ca867b23bfso282593a91.2 for ; Wed, 10 Jul 2024 06:03:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1720616636; x=1721221436; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=lCpMXD5GVv2p1k00aa2qP4hVdZF4Dhc4OTsVg433NXE=; b=Pj284emrFLDqvjw3+aQgGoct2lASBUYonrC3F+JcwwI1mElDxlHfRzDHo4vdqVRPdV hb6c0qreaSVD1QOePn0DzotTp4/KOVufVwqrW6VPI4NQ5InVvKK9jnhiEuWWH/7lhCwv lz7+g5dpSP+j/X6CNCTMNSN2ovhTWgOWpIfkcDisTy2VXhcla6VvtL+MG6TS3ZId6ur6 8NWCJ5fqEDGLmPbTPiyDwIXl4cNdoZnoYJhUMS1zZ/HnCQjbrbCDdDRxPevair5mAcMk brLt90PfspJf+F5jE6W++seOBt/Cm74kG9jS6RLmL3ZBXf58U8F+zG3CVrVE+KgBgKmD 7p3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1720616636; x=1721221436; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lCpMXD5GVv2p1k00aa2qP4hVdZF4Dhc4OTsVg433NXE=; b=oZPfThF/Yer8EIDF+nkqeDI7jhu/y0mT8jsVEbapOSB3nkMGms0DF2KHBPHiQxVeyx BzfKJH9WldVhM6qY4EJlNUh744OHf8DA2PcNLJufYVWc+8lKfMB35jmWN8Qyqu/cTI1w YZ0NESNMc/sMsGV2Qz6LS548VJAV5G7xnoPwBdSC+WOk7o4/ZPs+gdj+O9LLTx1o06sc qT3m91kuiHTsfU8wQwn2kPXdwVFfLW0cQzl5Gr723R3xFuvOwic3uA4r+Rg8wz/4o9iq d1puA3lE293nd9y85MvDKOXLBWyaBlxoxBGj7w4IbBIDke3eGrbD7BehM8jcv9qtr1dF ox8Q== X-Gm-Message-State: AOJu0YwGIEKrLFiNnS1xDzFzCaBS+/blI0vlHDaZ+FufMU/L72X/WxqB L4gqZqNWAA+E0ntuRZWqweYwxQXxqssvAGuMThOgLESFITcQDM6EYaih2WyEmDb7S9/wWe7sFFD 3pCXqMRlhvuYfZjd8kLOfrFbYakQ4wh78 X-Google-Smtp-Source: AGHT+IHZnw4/fxw/zFncGFAKV21/Emp3/yFZwMb7BayGAi6Gv1YazmkG9W7/PcbbxI9y+AF+CJja5sMPRT+m8UhUll8= X-Received: by 2002:a17:90b:247:b0:2c8:7897:eb46 with SMTP id 98e67ed59e1d1-2ca35d3c73dmr4180163a91.37.1720616636399; Wed, 10 Jul 2024 06:03:56 -0700 (PDT) MIME-Version: 1.0 References: <71cf3e97-a0a5-4a94-add8-989cd1e2311d@aklaver.com> In-Reply-To: From: Hans Schou Date: Wed, 10 Jul 2024 15:03:39 +0200 Message-ID: Subject: Re: Finding error in long input file To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000684f2a061ce44799" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000684f2a061ce44799 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 T24gV2VkLCBKdWwgMTAsIDIwMjQgYXQgMjo1OeKAr1BNIERhdmlkIEcuIEpvaG5zdG9uIDwNCmRh dmlkLmcuam9obnN0b25AZ21haWwuY29tPiB3cm90ZToNCg0KPg0KPiBBbmQgd2hhdCBhcmUgdGhl IGZpcnN0IGZldyBsaW5lcyBvZiB0aGUgZmlsZT8gVXNlIHRleHQsIG5vdCBzY3JlZW5zaG90cy4N Cj4NCg0KWWVzIHRoZSBsaW5lIHdpdGggJ0lOU0VSVCcNCg0KZ3JlcCAtbmkgJ0lOU0VSVCBJTlRP JyBzY3JpcHRzL2luc2VydC1hZGRycy5zcWwNCg0KDQotLSANCvCdlbPwnZaG8J2Wk/Cdlpgg8J2V vvCdlojwnZaN8J2WlPCdlpoNCuKYjyDinoHinoEg4p6F4p6DIOKeh+KTqiDinoHik6oNCg== --000000000000684f2a061ce44799 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Wed, Jul 10, 2024 at 2:59=E2=80=AF= PM David G. Johnston <davi= d.g.johnston@gmail.com> wrote:

And what are the first few lines = of the file? Use text, not screenshots.

Yes the line with 'INSERT'

grep -ni = 9;INSERT INTO'=C2=A0scripts/insert-addrs.sql


--
=F0= =9D=95=B3=F0=9D=96=86=F0=9D=96=93=F0=9D=96=98=C2=A0=F0=9D=95=BE=F0=9D=96=88= =F0=9D=96=8D=F0=9D=96=94=F0=9D=96=9A
=E2=98=8F =E2=9E=81=E2= =9E=81 =E2=9E=85=E2=9E=83 =E2=9E=87=E2=93=AA =E2=9E=81=E2=93=AA
--000000000000684f2a061ce44799--