Re: Display Bytea field

Adrian Klaver <adrian.klaver@aklaver.com>

From: Adrian Klaver <adrian.klaver@aklaver.com>

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>

Date: 2025-01-12T00:25:17Z

Lists: pgsql-general

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