Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lyrGP-00057n-6r for pgsql-admin@arkaria.postgresql.org; Thu, 01 Jul 2021 07:37:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lyrGN-0000Dr-Pi for pgsql-admin@arkaria.postgresql.org; Thu, 01 Jul 2021 07:37:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lyrGN-0000Dj-Cu for pgsql-admin@lists.postgresql.org; Thu, 01 Jul 2021 07:37:31 +0000 Received: from mail-ej1-x633.google.com ([2a00:1450:4864:20::633]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lyrGK-0000jZ-R7 for pgsql-admin@lists.postgresql.org; Thu, 01 Jul 2021 07:37:30 +0000 Received: by mail-ej1-x633.google.com with SMTP id bu12so8921846ejb.0 for ; Thu, 01 Jul 2021 00:37:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=GarthuNLG5pEIWBOfkKd35t8SthljdyDLwnj85CJHs0=; b=02rkfx3s5bXSBwL35IlVOqcnJoVFexzXtOJm6hxbmHSJvGmk4HFv33Ybmfv7Gj3SyR OZP6XvthcaziMUkCYTX5Au/OvdqOxmgvrDdlX86GU+65N2mQCzDZTkz3aGur999zO6+H jVXp5il+FtodpbuYTZ6kIsidUPpPcW8Pv5L7GLVWPkcr22BqEfgBzk9icWIb7L1t8RlA JDKR3l9ICz9ONUKflvlD0THUC4/C/c2cSPpIrQvGgwnalGYfCEyWvcAbacdyXo7GcV1j lysq2x8FGWTy09t2aVPkkCbasVz7/JSaYsExexzlWL1MtuG2FjKPgHtL0w/ymy5o6lgn YqHw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=GarthuNLG5pEIWBOfkKd35t8SthljdyDLwnj85CJHs0=; b=a+xo+kbVgyecZ7sVmNokynzJ9r4O1BHy9k00Smaw4rGoytR1n04hTE/9vMnH8Nb27h 2QzoBKi/6kJ6hl0XobHQWECl6pKmGMZ+fbsCr8udP2rFbzsp3jAAVZ0Rtt+2lvoyk1Te TQ5hsZ9Ba/J7GAiTtY6fsHYZheMTV9GaAQ9VXp/iMUGX66H1dmQTQ3lPS2a1zamZ0hJo 8IwD3FXHsv/BAIYnTfcQt/Wc1F9J3Qm6j2JbQxxEu9bJZ4fj4NNW2KZ3H3TeH7K6xcZs HVLDXMtocz2stUYes2P4TZZ/fHcUh5Jc5dNfX7wiz+UcYS+IWeiy2zQI0zaaYFwwOWFz QxCA== X-Gm-Message-State: AOAM531xxBFuttKpcoKFoVvxG3FwMeb12+nnPQu/Es0e6M+or+CLxlPH R9ydk1iXEgryNEr1fOmRTU5fjg== X-Google-Smtp-Source: ABdhPJxogWLIbyY3g8fvDHpmEAUaTP7vntLvsSRG4c7/Arav+Lh4SN7BRVFseQB1cmIzBAO1E3FTVg== X-Received: by 2002:a17:906:6dc5:: with SMTP id j5mr39178513ejt.364.1625125046965; Thu, 01 Jul 2021 00:37:26 -0700 (PDT) Received: from localhost.localdomain (217-149-174-251.nat.highway.telekom.at. [217.149.174.251]) by smtp.gmail.com with ESMTPSA id x16sm2270566edq.62.2021.07.01.00.37.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 01 Jul 2021 00:37:26 -0700 (PDT) Message-ID: <8a70f9f6d154644f6c7f000e661a7f0779cba774.camel@cybertec.at> Subject: Re: Invalid byte sequence From: Laurenz Albe To: Yambu , Pgsql-admin Date: Thu, 01 Jul 2021 09:37:26 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2021-07-01 at 09:29 +0200, Yambu wrote: > ERROR: invalid byte sequence for encoding "UTF8": 0x00 > CONTEXT: COPY table1, line 377617 That means that there is an ASCII 0 byte in a string somewhere in the file. This character is not allowed in strings in PostgreSQL. You will have to fix the data before you can load them into PostgreSQL. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com