Hi,
I am getting Cannot have quote-char in plain field:['{"] error when trying to 
insert a JSON string into a Postgres DB table using JDBC request.
I tried the following but nothing worked:   
   - place the JSON string in single quotes, 
   - escaping the double quotes with \", 
   - placing the string in $$<JSON string here>$$ but nothing worked. 
There is no issue with the connection and other select/insert queries and I was 
able to insert from pgAdmin with the same string in single quotes though.
The JSON string looks like this: {"A":"A", "B":[{"C":"C"}]}
I am really out of ideas at this time. Can someone help?
Thanks,Jun

Reply via email to