Re: Display Bytea field - Mailing list pgsql-general

I still have csv files and loaded right into PG no decoding and look like this little snippet and I did the COpy command into PG 

"/9j/4AAQSkZJRgABAQAAAQABAAD

On Sat, Jan 11, 2025 at 11:50 AM Adrian Klaver <adrian.klaver@aklaver.com> wrote:

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.
>