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