InfoTable cannot be read as PGSQL Variables

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

Best answer by supandey

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

Answer

5-Regular Member

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

Sign up