I bet Image*Source* doesn't contain what you think it does. I'd query that table using SSMS, to see what's really in that column.
On Sat, Jan 11, 2025 at 6:49 PM Andy Hartman <hartman60h...@gmail.com> wrote: > 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.kla...@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 <e...@ewie.name >> > <mailto:e...@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. >> > >> > -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster!
