cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

InfoTable cannot be read as PGSQL Variables

LeeGwangmin
3-Visitor

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 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
supandey
19-Tanzanite
(To:LeeGwangmin)

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

View solution in original post

1 REPLY 1
supandey
19-Tanzanite
(To:LeeGwangmin)

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

Top Tags