public inbox for [email protected]help / color / mirror / Atom feed
Display Bytea field 4+ messages / 3 participants [nested] [flat]
* Display Bytea field @ 2025-01-09 20:16 Andy Hartman <[email protected]> 2025-01-09 20:17 ` Re: Display Bytea field Andy Hartman <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Andy Hartman @ 2025-01-09 20:16 UTC (permalink / raw) To: [email protected] I have migrated over a Table from Mssql that had an Image column I now have it in Postgres ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Display Bytea field 2025-01-09 20:16 Display Bytea field Andy Hartman <[email protected]> @ 2025-01-09 20:17 ` Andy Hartman <[email protected]> 2025-01-09 20:24 ` Re: Display Bytea field Ron Johnson <[email protected]> 2025-01-09 22:11 ` Re: Display Bytea field Adrian Klaver <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Andy Hartman @ 2025-01-09 20:17 UTC (permalink / raw) To: [email protected] 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 > ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Display Bytea field 2025-01-09 20:16 Display Bytea field Andy Hartman <[email protected]> 2025-01-09 20:17 ` Re: Display Bytea field Andy Hartman <[email protected]> @ 2025-01-09 20:24 ` Ron Johnson <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Ron Johnson @ 2025-01-09 20:24 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]> 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] 4+ messages in thread
* Re: Display Bytea field 2025-01-09 20:16 Display Bytea field Andy Hartman <[email protected]> 2025-01-09 20:17 ` Re: Display Bytea field Andy Hartman <[email protected]> @ 2025-01-09 22:11 ` Adrian Klaver <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Adrian Klaver @ 2025-01-09 22:11 UTC (permalink / raw) To: Andy Hartman <[email protected]>; [email protected] 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 what those binary strings represent. They could be an image, a PDF, a spreadsheet file, etc. 3) To achieve what you want you need some sort of client code that can take the binary strings and convert them to the correct output. Then you can match and display. > > On Thu, Jan 9, 2025 at 3:16 PM Andy Hartman <[email protected] > <mailto:[email protected]>> wrote: > > I have migrated over a Table from Mssql that had an Image column I > now have it in Postgres > -- Adrian Klaver [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2025-01-09 22:11 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-01-09 20:16 Display Bytea field Andy Hartman <[email protected]> 2025-01-09 20:17 ` Andy Hartman <[email protected]> 2025-01-09 20:24 ` Ron Johnson <[email protected]> 2025-01-09 22:11 ` 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