Hello, I have a problem that dataflow as saved infotable, and want to save PGSQL.
However, I have tried attached screenshot, I got below error message.
"Unable to Invoke Service insert_PanelData on Save_DB_PowerPanels : ERROR: syntax error at or near "[" Position: 46"
String, or Integer can be applied same nanner with no problem.
Awating good answers.
Thanks
Solved! Go to Solution.
Hi @LeeGwangmin could you try with this
insert into demojson (sno, info) values (3, '{"field1": "DemoName101", "field2" : "blah"}')
Info is the Json datatype in my table in the PostgreSQL
Hi @LeeGwangmin could you try with this
insert into demojson (sno, info) values (3, '{"field1": "DemoName101", "field2" : "blah"}')
Info is the Json datatype in my table in the PostgreSQL