By inserting data in a JSONB type column I got the following error message:
>>
ERROR: string too long to represent as jsonb string
DETAIL: Due to an implementation restriction, jsonb strings cannot exceed 268435455 bytes.
<<
could anyone confirm that there is a size limit for JSONB type fields ?
Have you looked at bytea datatype? I believe this would allow up to 1GB which is the max file size so the maximum (minus some overhead) for a row. Perhaps though, storing files of unusually large size should be done outside of the database.