Postgres JSONB column insert error: invalid input syntax for type json the input string ended unexpectedly

Viewed 1266

I'm trying to create a row manually via DBeaver and I am entering the following in a jsonb column:

{"US":"0.880","PA":"0.028","KY":"0.025"}

I've checked that this is valid JSON on https://jsonformatter.curiousconcept.com/#

However, this is what I get:

enter image description here

Any insight would be appreciated...

I even tried surrounding the object with single quotes like:

'{"US":"0.880","PA":"0.028","KY":"0.025"}'

But got an error about how the ' is an invalid token...

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

1 Answers
Related