public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Andy Hartman <[email protected]>
To: [email protected]
Subject: Re: Display Bytea field
Date: Thu, 9 Jan 2025 14:11:10 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>
References: <CAEZv3co=t+YzkTmRMPR8Ev1izcb8VxYg-7jB2RCHSQGATsdHSg@mail.gmail.com>
	<CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>

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]

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Display Bytea field
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox