>
> Hi
>>
>> 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.
