Re: Display Bytea field

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx