Trying to insert data in postgresql database.
In pgAdmin this statement is working.
I set up a similar test (with only the first two JSON fields and different table/column names) and it works just fine in NiFi. If yours is working in pgAdmin with hard-coded values then I'm guessing there is something with the NiFi Expressions. Assuming those are flow file attributes, do any of them have values that might contain a double-quote? In any case you may want to call escapeJson() on them before they are evaluated into the JSON object, such as: