Feedback-ID: i76984098:Fastmail
Message-ID: <e7852df3-0724-494a-a555-2b4413c05ec7@aklaver.com>
Date: Sat, 11 Jan 2025 16:08:32 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Display Bytea field
To: Andy Hartman <hartman60home@gmail.com>
Cc: Erik Wienhold <ewie@ewie.name>, Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <CAEZv3co=t+YzkTmRMPR8Ev1izcb8VxYg-7jB2RCHSQGATsdHSg@mail.gmail.com>
 <CAEZv3copeUd7mNf98qxBtkqqW=g3MtCJe62jdMEEzFC4M=-+4A@mail.gmail.com>
 <CANzqJaDRQU2KsJt76TgPpES8qVg3i_sv5cZSmo=qoSN4VUzwNw@mail.gmail.com>
 <CAEZv3cqebrs+GT1YmWdk4sko7hgtstVKkcP+2OS07UtJ48x=dA@mail.gmail.com>
 <10fe353b-a5ba-4522-badf-89119179b4f0@ewie.name>
 <CAEZv3cqQ-LRPLM8iMsKh_Wc023pdHiW34AeuuY9jH-OF8FUnqg@mail.gmail.com>
 <9374c94f-95cc-4fa6-a997-a8fd7acdf379@aklaver.com>
 <CAEZv3cpMxZLUKV_Nm9qw-dBohuThC5co-5-p_OPD5Lnf8kxrgA@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3cpMxZLUKV_Nm9qw-dBohuThC5co-5-p_OPD5Lnf8kxrgA@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/e7852df3-0724-494a-a555-2b4413c05ec7%40aklaver.com>
Precedence: bulk

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
adrian.klaver@aklaver.com