Re: Display Bytea field

On 1/11/25 16:09, Andy Hartman wrote: In mssql its a image datatype. Oops, I was referring to the wrong database(MySQL) in previous posts. So: Show command used to pull data from MS SQL Server. On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver > wrote: O

Re: Display Bytea field

In mssql its a image datatype. On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver wrote: > On 1/11/25 15:49, Andy Hartman 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 > > You have not answered: > > What

Re: Display Bytea field

On 1/11/25 15:49, Andy Hartman 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 You have not answered: What data type was used to store data in MySQL? Show command used to pull data from MySQL. "/9j/4AA

Re: Display Bytea field

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 wrote: > I still have csv files and loaded right into PG no decoding and look like > this little snippet and I did the C

Re: Display Bytea field

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 wrote: > On 1/11/25 03:05, Andy Hartman wrote: > > I used PS to pull the data from mssql

Re: Display Bytea field

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

Re: Display Bytea field

1. Do you still have the CSV file (or can you regenerate it from the still-existing MSSQL DB)? 2. Did you load the base64 string into PG, or did you decode before loading into PG? 3. A base64 string would be about 62KB. Either you did something wrong when loading, or the programmer is doing someth

Re: Display Bytea field

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 = [Convert]::ToBase64String($row.ImageSource) AFter data was loaded the developer said

Re: Display Bytea field

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 signature.asc Description: PGP signature

Re: Display Bytea field

On Fri, Jan 10, 2025 at 7:49 AM Daniel Verite wrote: [snip] > Alternatively, you could compare image checksums before and > after moving them into postgres. The advantage is that you > don't need to export or view any file, and you compare globally > all your images. If the checksums are identica

Re: Display Bytea field

Andy Hartman wrote: > How thru a simple query can I make sure data matches and I can display it > > On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman wrote: > > > I have migrated over a Table from Mssql that had an Image column I now > > have it in Postgres Within psql, the bytea field can b

Re: Display Bytea field

Maybe tools like DBeaver can help? It has a free trial period. Andy Hartman escribió: could it be done using Powershell? 

Re: Display Bytea field

On 1/9/25 12:17, Andy Hartman wrote: How thru a simple query can I make sure data matches and I can display it What you are facing: 1) Bytea stores binary strings in the formats specified here: https://www.postgresql.org/docs/current/datatype-binary.html 2) The database has no 'knowledge' of

Re: Display Bytea field

Sure. There's at least one Postgresql driver for PS, and Google says there are 3rd party libraries to display images. It's just a Simple Matter Of Programming! On Thu, Jan 9, 2025 at 3:31 PM Andy Hartman wrote: > could it be done using Powershell? > > On Thu, Jan 9, 2025 at 3:25 PM Ron Johnson

Re: Display Bytea field

could it be done using Powershell? On Thu, Jan 9, 2025 at 3:25 PM Ron Johnson wrote: > On Thu, Jan 9, 2025 at 3:17 PM Andy Hartman > wrote: > >> How thru a simple query can I make sure data matches and I can display it >> >> On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman >> wrote: >> >>> I have m

Re: Display Bytea field

On Thu, Jan 9, 2025 at 3:17 PM Andy Hartman wrote: > How thru a simple query can I make sure data matches and I can display it > > On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman > wrote: > >> I have migrated over a Table from Mssql that had an Image column I now >> have it in Postgres >> > Did SSMS

Re: Display Bytea field

How thru a simple query can I make sure data matches and I can display it On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman wrote: > I have migrated over a Table from Mssql that had an Image column I now > have it in Postgres >