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 <[email protected] <mailto:[email protected]>> 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
    [email protected] <mailto:[email protected]>


--
Adrian Klaver
[email protected]



Reply via email to