Re: Display Bytea field - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Display Bytea field
Date
Msg-id e7852df3-0724-494a-a555-2b4413c05ec7@aklaver.com
Whole thread Raw
In response to Re: Display Bytea field  (Andy Hartman <hartman60home@gmail.com>)
Responses Re: Display Bytea field
List pgsql-general
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




pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Display Bytea field
Next
From: Andy Hartman
Date:
Subject: Re: Display Bytea field