Feedback-ID: i76984098:Fastmail
Message-ID: <9374c94f-95cc-4fa6-a997-a8fd7acdf379@aklaver.com>
Date: Sat, 11 Jan 2025 08:50:06 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Display Bytea field
To: Andy Hartman <hartman60home@gmail.com>, Erik Wienhold <ewie@ewie.name>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAEZv3co=t+YzkTmRMPR8Ev1izcb8VxYg-7jB2RCHSQGATsdHSg@mail.gmail.com>
 <CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>
 <CANzqJaDRQU2KsJt76TgPpES8qVg3i_sv5cZSmo=qoSN4VUzwNw@mail.gmail.com>
 <CAEZv3cqebrs+GT1YmWdk4sko7hgtstVKkcP+2OS07UtJ48x=dA@mail.gmail.com>
 <10fe353b-a5ba-4522-badf-89119179b4f0@ewie.name>
 <CAEZv3cqQ-LRPLM8iMsKh_Wc023pdHiW34AeuuY9jH-OF8FUnqg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3cqQ-LRPLM8iMsKh_Wc023pdHiW34AeuuY9jH-OF8FUnqg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/9374c94f-95cc-4fa6-a997-a8fd7acdf379%40aklaver.com>
Precedence: bulk

On 1/11/25 03:05, Andy Hartman wrote:
> I used PS to pull the data from mssql  to Postgres dumping data to csv. 
> I then used csv to load Postgres and the table that has Bytea

What data type was used to store data in MySQL?

Show command used to pull data from MySQL.

> 
> # Convert the image data to a base64 string  -- powershell
>      $base64Image = [Convert]::ToBase64String($row.ImageSource)
> 
> AFter data was loaded the developer said in his app frontend that the 
> Image wouldn't open thru his code. -- I'm trying to get that code to 
> help debug
> 
> He said the size of the array is 1368. from bytea The size coming from 

How does an array enter into this?


> the SQL-Server db is 46935 and the image correctly appears...
> 
> Could that be caused by my PS dump to csv process or maybe still a 
> code(frontend) issue..
> 
> Still trying to figure out using a single record if data loaded to the 
> bytea field matches the mssql record.
> 
> I tried to use the tool SimplySql to connect mssql to postgresql to 
> transfer data but it failed  ...
> 
> any help would be appreciated..
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> On Fri, Jan 10, 2025 at 12:35 PM Erik Wienhold <ewie@ewie.name 
> <mailto:ewie@ewie.name>> wrote:
> 
>     On 2025-01-09 21:31 +0100, Andy Hartman wrote:
>      > could it be done using Powershell?
> 
>     I use this: https://blog.cleverelephant.ca/2021/04/psql-binary.html
>     <https://blog.cleverelephant.ca/2021/04/psql-binary.html>
>     But I don't know if that translates to PowerShell.
> 
>     -- 
>     Erik Wienhold
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com