Re: Display Bytea field

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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com