JSONB maximal length ?

From: ROS Didier <didier(dot)ros(at)edf(dot)fr>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: JSONB maximal length ?
Date: 2019-09-28 16:11:44
Message-ID: e3725271efdd4f8988457e88cef03bf6@PCYINTPEXMU001.NEOPROD.EDF.FR
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks in advance

Best Regards
Didier ROS
EDF

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2019-09-28 16:25:59 Re: JSONB maximal length ?
Previous Message Andrew Gierth 2019-09-28 15:59:55 Re: Possible bug: SQL function parameter in window frame definition