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 > >