MIME-Version: 1.0
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>
In-Reply-To: <10fe353b-a5ba-4522-badf-89119179b4f0@ewie.name>
From: Andy Hartman <hartman60home@gmail.com>
Date: Sat, 11 Jan 2025 06:05:31 -0500
Message-ID: <CAEZv3cqQ-LRPLM8iMsKh_Wc023pdHiW34AeuuY9jH-OF8FUnqg@mail.gmail.com>
Subject: Re: Display Bytea field
To: Erik Wienhold <ewie@ewie.name>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000031e810062b6c31a0"
Archived-At: <https://www.postgresql.org/message-id/CAEZv3cqQ-LRPLM8iMsKh_Wc023pdHiW34AeuuY9jH-OF8FUnqg%40mail.gmail.com>
Precedence: bulk

--00000000000031e810062b6c31a0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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

# Convert the image data to a base64 string  -- powershell
    $base64Image =3D [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 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=E2=80=AFPM Erik Wienhold <ewie@ewie.name> wro=
te:

> 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
> But I don't know if that translates to PowerShell.
>
> --
> Erik Wienhold
>

--00000000000031e810062b6c31a0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr">I used PS to pull the da=
ta from mssql=C2=A0 to Postgres dumping data to csv. I then used csv to loa=
d Postgres and the table that has Bytea<br><br><div># Convert the image dat=
a to a base64 string=C2=A0 -- powershell</div><div>=C2=A0 =C2=A0 $base64Ima=
ge =3D [Convert]::ToBase64String($row.ImageSource)<br><br>AFter data was lo=
aded the developer said in his app frontend that the Image wouldn&#39;t ope=
n thru his code. -- I&#39;m trying to get that code to help debug<br><br><s=
pan>He said=C2=A0the size of the array is 1368. from bytea The size coming =
from the SQL-Server db is 46935 and the image correctly appears...<br><br>C=
ould that be caused by my PS dump to csv process or maybe still a code(fron=
tend) issue..</span></div><div><span><br></span></div><div><span>Still tryi=
ng to figure out using a single record if data loaded to the bytea field ma=
tches the mssql record.<br><br>I tried to use the tool SimplySql to connect=
 mssql to postgresql to transfer data but it failed=C2=A0 ...=C2=A0<br><br>=
any help=C2=A0would be appreciated..<br><br><br><br><br><br></span></div><d=
iv><br></div><div><br><br><br></div></div></div></div><br><div class=3D"gma=
il_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fr=
i, Jan 10, 2025 at 12:35=E2=80=AFPM Erik Wienhold &lt;<a href=3D"mailto:ewi=
e@ewie.name">ewie@ewie.name</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex">On 2025-01-09 21:31 +0100, Andy Hartman wrote:<b=
r>
&gt; could it be done using Powershell?<br>
<br>
I use this: <a href=3D"https://blog.cleverelephant.ca/2021/04/psql-binary.h=
tml" rel=3D"noreferrer" target=3D"_blank">https://blog.cleverelephant.ca/20=
21/04/psql-binary.html</a><br>
But I don&#39;t know if that translates to PowerShell.<br>
<br>
-- <br>
Erik Wienhold<br>
</blockquote></div>

--00000000000031e810062b6c31a0--