I have a retool app connected to a PostgreSQL database.
I auto-generated an add form for a table using the autogenerate feature.
The table has a JSON field called
When I am trying to submit the form, I am getting the following error from PostgreSQL:
This is a screenshot of the query attached to the form:
I expected this to work out of the box but it doesn't. I assume this has something to do with escaping the quotes in the JSON, but shouldn't retool do that automatically. How would JSON field inserts work otherwise?
Can someone help? I don't want to write a transformer for every JSON field to escape the characters (in case that's the root cause)