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 1rPkWs-00DsIl-CZ for pgsql-general@arkaria.postgresql.org; Tue, 16 Jan 2024 14:35: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 1rPkWr-004KIW-Et for pgsql-general@arkaria.postgresql.org; Tue, 16 Jan 2024 14:35:01 +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 1rPkWr-004KIO-3s for pgsql-general@lists.postgresql.org; Tue, 16 Jan 2024 14:35:01 +0000 Received: from mail-pg1-x536.google.com ([2607:f8b0:4864:20::536]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rPkWk-00286H-AL for pgsql-general@lists.postgresql.org; Tue, 16 Jan 2024 14:35:00 +0000 Received: by mail-pg1-x536.google.com with SMTP id 41be03b00d2f7-5ce07cf1e5dso5031798a12.2 for ; Tue, 16 Jan 2024 06:34:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1705415691; x=1706020491; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=5X+UON0JHYm6CHAQbsFO1yi6/G3ksyUwcCSWIQ/hxPo=; b=eg0tvN9cUZnk/LrrUpSI6c4VJNPYhAZV5nzS3tb81JtUJMCAGm9vDyCGspD3Ti37yJ GyOLfasZzTjtyJ9pRfguNyaV18gLfi+/ZE7hKCJyXgslMCX/dW4QwmQM0ijbV1HuGEqf rDzPXtTgzLapGipAutVnlfsDkXo7I15p1EgVdD8qNWJPdIickTlt1ENbsbld2QkOqPwp +Z5vDdjM8v3OYGgfOjfur8Fhlbp0ssXlsNRcqMIFhPqOXKflG8iNt3v5XCjzZ5RreE21 fdLLA9hkipxaz7G1OTxcjF1po6KWwWm4EMzxhheTwh7eK/wB+NYFtZXw3r3suaLrH+j+ z7QA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1705415691; x=1706020491; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=5X+UON0JHYm6CHAQbsFO1yi6/G3ksyUwcCSWIQ/hxPo=; b=TIzUv0NqQXXfPthTOVoBgdFdfXI/mPsuxRiJjTea62PkFCjKPvDQtwtwqMWwvwv/eb vs9wgHoS1V2z7IOq5LrrfCjfXUPOhbNOcJbXRV2fHSpo22zXfOj/HnwRB878UxQV2Xf0 9wLcgLPAVc9bKqF+CKzBPwwOa8ksJ9bQeCuVjSKGbslVJ6YPTzuigY126wt0+Q742Gpt f9zn07VAUVcpesFVwjGARtgTGaGqUKHKEuatDgj9wS+1hGfT9mAoDl+OAuny3wPDWoBT +Q03K/Vzd3lI+X570wBRrMqORCfqDd6Po4RO5RFOvy5SxeD4GNsy4pJMexPbmp0z63nd D87Q== X-Gm-Message-State: AOJu0YwWClljGX4zaH0y/pZt/PRcqQUP98DJGsfwnXG1jks2XoLgHZ65 ew3aNBcFhGHeD4+xfFCEEeNqXxFwsK0= X-Google-Smtp-Source: AGHT+IENODF2HaDGFic6BOKL3TMFDJJLXHTrVgjwOwUa+TPKEqDSevIt1pErWKF7dmjAOkq2sNlbvA== X-Received: by 2002:a17:90a:6c23:b0:28c:61c6:4fe8 with SMTP id x32-20020a17090a6c2300b0028c61c64fe8mr3210766pjj.88.1705415691478; Tue, 16 Jan 2024 06:34:51 -0800 (PST) Received: from [192.168.1.3] (c-76-140-27-218.hsd1.ut.comcast.net. [76.140.27.218]) by smtp.gmail.com with ESMTPSA id sj4-20020a17090b2d8400b0028d9b5d41edsm11825457pjb.38.2024.01.16.06.34.50 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 16 Jan 2024 06:34:51 -0800 (PST) Content-Type: multipart/alternative; boundary="------------7LQSazNNwRh48es4BSdg0mtd" Message-ID: Date: Tue, 16 Jan 2024 07:34:49 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: postgres sql assistance Content-Language: en-CA To: pgsql-general@lists.postgresql.org References: From: Rob Sargent In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------7LQSazNNwRh48es4BSdg0mtd Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 1/16/24 06:00, Raul Giucich wrote: > Hi Arun, can you share the sql used for this insert. Visually it seems > some character are affecting the data. > Best regards, > Raul > Raul, the OP attached the sq. --------------7LQSazNNwRh48es4BSdg0mtd Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
On 1/16/24 06:00, Raul Giucich wrote:
Hi Arun, can you share the sql used for this insert. Visually it seems some character are affecting the data.
Best regards,
Raul

Raul, the OP attached the sq.

--------------7LQSazNNwRh48es4BSdg0mtd--