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.kla...@aklaver.com <mailto:adrian.kla...@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 <https://www.postgresql.org/docs/current/datatype-binary.html> And the above does not look like either.-- Adrian Klaveradrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
-- Adrian Klaver adrian.kla...@aklaver.com
