title: Postgres JSONB column insert error: invalid input syntax for type json the input string ended unexpectedly
body: <p>I'm trying to create a row manually via DBeaver and I am entering the following in a jsonb column:</p>
  <pre><code>{&quot;US&quot;:&quot;0.880&quot;,&quot;PA&quot;:&quot;0.028&quot;,&quot;KY&quot;:&quot;0.025&quot;}
  </code></pre>
  <p>I've checked that this is valid JSON on <a href="https://jsonformatter.curiousconcept.com/#" rel="nofollow noreferrer">https://jsonformatter.curiousconcept.com/#</a></p>
  <p>However, this is what I get:</p>
  <p><a href="https://i.stack.imgur.com/qz29J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qz29J.png" alt="enter image description here" /></a></p>
  <p>Any insight would be appreciated...</p>
  <p>I even tried surrounding the object with single quotes like:</p>
  <pre><code>'{&quot;US&quot;:&quot;0.880&quot;,&quot;PA&quot;:&quot;0.028&quot;,&quot;KY&quot;:&quot;0.025&quot;}'
  </code></pre>
  <p>But got an error about how the ' is an invalid token...</p>
  <p>I was writing a nodejs script to insert a json stringified object into the column but I was getting the same error so I decided to manually try it and I can't even insert the above data...</p>