Re: Display Bytea field

Andy Hartman <hartman60home@gmail.com>

From: Andy Hartman <hartman60home@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.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:09:44Z
Lists: pgsql-general
In mssql its a image datatype.

On Sat, Jan 11, 2025 at 7:08 PM Adrian Klaver <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
>
> And the above does not look like either.
>
>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>