Feedback-ID: i76984098:Fastmail
Message-ID: <bd445dc6-4a71-42e2-b176-f32abe4f5c9c@aklaver.com>
Date: Thu, 9 Jan 2025 14:11:10 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Display Bytea field
To: Andy Hartman <hartman60home@gmail.com>, pgsql-general@lists.postgresql.org
References: <CAEZv3co=t+YzkTmRMPR8Ev1izcb8VxYg-7jB2RCHSQGATsdHSg@mail.gmail.com>
 <CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/bd445dc6-4a71-42e2-b176-f32abe4f5c9c%40aklaver.com>
Precedence: bulk

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 <hartman60home@gmail.com 
> <mailto:hartman60home@gmail.com>> wrote:
> 
>     I have migrated over a Table from Mssql that had an Image column I
>     now have it in Postgres
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com