public inbox for [email protected]help / color / mirror / Atom feed
Re: Display Bytea field 12+ messages / 5 participants [nested] [flat]
* Re: Display Bytea field @ 2025-01-09 20:31 Andy Hartman <[email protected]> 0 siblings, 3 replies; 12+ messages in thread From: Andy Hartman @ 2025-01-09 20:31 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> could it be done using Powershell? On Thu, Jan 9, 2025 at 3:25 PM Ron Johnson <[email protected]> wrote: > On Thu, Jan 9, 2025 at 3:17 PM Andy Hartman <[email protected]> > 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 <[email protected]> >> wrote: >> >>> I have migrated over a Table from Mssql that had an Image column I now >>> have it in Postgres >>> >> > Did SSMS see the column, and then display thousands (or millions) of > images? > > What you're going to need here is a GUI app (that can be a web app) which > "you" have programmed to know *that column is full of JPEG (or PNG or > whatever) images*, and so call the relevant decoding library then display > at the appropriate location in a window. > > -- > Death to <Redacted>, and butter sauce. > Don't boil me, I'm still alive. > <Redacted> lobster! > ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-09 20:37 Ron Johnson <[email protected]> parent: Andy Hartman <[email protected]> 2 siblings, 0 replies; 12+ messages in thread From: Ron Johnson @ 2025-01-09 20:37 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]> 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 <[email protected]> wrote: > could it be done using Powershell? > > On Thu, Jan 9, 2025 at 3:25 PM Ron Johnson <[email protected]> > wrote: > >> On Thu, Jan 9, 2025 at 3:17 PM Andy Hartman <[email protected]> >> 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 <[email protected]> >>> wrote: >>> >>>> I have migrated over a Table from Mssql that had an Image column I now >>>> have it in Postgres >>>> >>> >> Did SSMS see the column, and then display thousands (or millions) of >> images? >> >> What you're going to need here is a GUI app (that can be a web app) which >> "you" have programmed to know *that column is full of JPEG (or PNG or >> whatever) images*, and so call the relevant decoding library then >> display at the appropriate location in a window. >> >> -- >> Death to <Redacted>, and butter sauce. >> Don't boil me, I'm still alive. >> <Redacted> lobster! >> > -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster! ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-09 22:10 [email protected] parent: Andy Hartman <[email protected]> 2 siblings, 0 replies; 12+ messages in thread From: [email protected] @ 2025-01-09 22:10 UTC (permalink / raw) To: [email protected] Maybe tools like DBeaver can help? It has a free trial period. Andy Hartman <[email protected]> escribió: > could it be done using Powershell? ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-10 17:35 Erik Wienhold <[email protected]> parent: Andy Hartman <[email protected]> 2 siblings, 1 reply; 12+ messages in thread From: Erik Wienhold @ 2025-01-10 17:35 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> 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 Attachments: [application/pgp-signature] signature.asc (228B, 2-signature.asc) download ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-11 11:05 Andy Hartman <[email protected]> parent: Erik Wienhold <[email protected]> 0 siblings, 2 replies; 12+ messages in thread From: Andy Hartman @ 2025-01-11 11:05 UTC (permalink / raw) To: Erik Wienhold <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> 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 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 PM Erik Wienhold <[email protected]> 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 > But I don't know if that translates to PowerShell. > > -- > Erik Wienhold > ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-11 12:50 Ron Johnson <[email protected]> parent: Andy Hartman <[email protected]> 1 sibling, 0 replies; 12+ messages in thread From: Ron Johnson @ 2025-01-11 12:50 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]> 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 something wrong. 4. When I migrated from Oracle LOBs to PB bytea, the Perl program ora2pg generated CSV files with "hex" strings for those columns. They were preceded by "\x", I think. They loaded directly into the PG database, with the COPY command. On Sat, Jan 11, 2025 at 6:05 AM Andy Hartman <[email protected]> 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 > > # 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 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 <[email protected]> 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 >> But I don't know if that translates to PowerShell. >> >> -- >> Erik Wienhold >> > -- Death to <Redacted>, and butter sauce. Don't boil me, I'm still alive. <Redacted> lobster! ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-11 16:50 Adrian Klaver <[email protected]> parent: Andy Hartman <[email protected]> 1 sibling, 1 reply; 12+ messages in thread From: Adrian Klaver @ 2025-01-11 16:50 UTC (permalink / raw) To: Andy Hartman <[email protected]>; Erik Wienhold <[email protected]>; +Cc: Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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 [email protected] ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-11 23:49 Andy Hartman <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 2 replies; 12+ messages in thread From: Andy Hartman @ 2025-01-11 23:49 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Erik Wienhold <[email protected]>; Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> 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 <[email protected]> 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 <[email protected] > > <mailto:[email protected]>> 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 > [email protected] > > ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-12 00:03 Ron Johnson <[email protected]> parent: Andy Hartman <[email protected]> 1 sibling, 0 replies; 12+ messages in thread From: Ron Johnson @ 2025-01-12 00:03 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]>; Andy Hartman <[email protected]> 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 <[email protected]> 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 <[email protected]> > 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 <[email protected] >> > <mailto:[email protected]>> 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! ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-12 00:08 Adrian Klaver <[email protected]> parent: Andy Hartman <[email protected]> 1 sibling, 1 reply; 12+ messages in thread From: Adrian Klaver @ 2025-01-12 00:08 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: Erik Wienhold <[email protected]>; Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> 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/4AAQSkZJRgABAQAAAQABAAD Are you sure? The acceptable formats are shown here: https://www.postgresql.org/docs/current/datatype-binary.html And the above does not look like either. -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-12 00:09 Andy Hartman <[email protected]> parent: Adrian Klaver <[email protected]> 0 siblings, 1 reply; 12+ messages in thread From: Andy Hartman @ 2025-01-12 00:09 UTC (permalink / raw) To: Adrian Klaver <[email protected]>; +Cc: Erik Wienhold <[email protected]>; Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> In mssql its a image datatype. On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver <[email protected]> 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 data type was used to store data in MySQL? > > Show command used to pull data from MySQL. > > > > > > "/9j/4AAQSkZJRgABAQAAAQABAAD > > Are you sure? > > The acceptable formats are shown here: > > https://www.postgresql.org/docs/current/datatype-binary.html > > And the above does not look like either. > > > > > -- > Adrian Klaver > [email protected] > > ^ permalink raw reply [nested|flat] 12+ messages in thread
* Re: Display Bytea field @ 2025-01-12 00:25 Adrian Klaver <[email protected]> parent: Andy Hartman <[email protected]> 0 siblings, 0 replies; 12+ messages in thread From: Adrian Klaver @ 2025-01-12 00:25 UTC (permalink / raw) To: Andy Hartman <[email protected]>; +Cc: Erik Wienhold <[email protected]>; Ron Johnson <[email protected]>; pgsql-generallists.postgresql.org <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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 data type was used to store data in MySQL? > > Show command used to pull data from MySQL. > > > > > > "/9j/4AAQSkZJRgABAQAAAQABAAD > > Are you sure? > > The acceptable formats are shown here: > > https://www.postgresql.org/docs/current/datatype-binary.html > <https://www.postgresql.org/docs/current/datatype-binary.html; > > And the above does not look like either. > > > > > -- > Adrian Klaver > [email protected] <mailto:[email protected]> > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 12+ messages in thread
end of thread, other threads:[~2025-01-12 00:25 UTC | newest] Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-01-09 20:31 Re: Display Bytea field Andy Hartman <[email protected]> 2025-01-09 20:37 ` Ron Johnson <[email protected]> 2025-01-09 22:10 ` [email protected] 2025-01-10 17:35 ` Erik Wienhold <[email protected]> 2025-01-11 11:05 ` Andy Hartman <[email protected]> 2025-01-11 12:50 ` Ron Johnson <[email protected]> 2025-01-11 16:50 ` Adrian Klaver <[email protected]> 2025-01-11 23:49 ` Andy Hartman <[email protected]> 2025-01-12 00:03 ` Ron Johnson <[email protected]> 2025-01-12 00:08 ` Adrian Klaver <[email protected]> 2025-01-12 00:09 ` Andy Hartman <[email protected]> 2025-01-12 00:25 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox