Tom Lane writes:
thought it was all one long line and tried to read it all in at once.
What's the history of your datafile --- has it maybe gotten passed
through a Windows newline conversion?
The database has emails.
The table in question holds the attachments. Each row represents one
attachment. The file to be inserted is hex64 encoded before insertion.
The email capture and hex64 conversion are both done on FreeBSD machines.
Although it never passes through a windows machine the attachments for the
most part are coming from windows machines.