| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Andy Hartman <hartman60home(at)gmail(dot)com> |
| Cc: | Erik Wienhold <ewie(at)ewie(dot)name>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Display Bytea field |
| Date: | 2025-01-12 00:08:32 |
| Message-ID: | e7852df3-0724-494a-a555-2b4413c05ec7@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andy Hartman | 2025-01-12 00:09:44 | Re: Display Bytea field |
| Previous Message | Ron Johnson | 2025-01-12 00:03:28 | Re: Display Bytea field |