Feedback-ID: i76984098:Fastmail
Message-ID: <a143e593-c380-48da-96f4-e48ecd869f65@aklaver.com>
Date: Sat, 11 Jan 2025 16:25:17 -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>
 <e7852df3-0724-494a-a555-2b4413c05ec7@aklaver.com>
 <CAEZv3coWB7MYcoF807cQU4Ym2veuuZtBHEuUZzqa_kd7Pdedyg@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAEZv3coWB7MYcoF807cQU4Ym2veuuZtBHEuUZzqa_kd7Pdedyg@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/a143e593-c380-48da-96f4-e48ecd869f65%40aklaver.com>
Precedence: bulk

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

-- 
Adrian Klaver
adrian.klaver@aklaver.com