I use postgreSQL to extract data as a datashape from the database. Everything seems OK. The columns from database are shown as follows:
But when I write SQL script "select * from LiftStatus", Error happen
What is the problem?
Hi Tiantian, just to confirm did you save the Entity before testing the service?
I have saved Entity before testing the service.
I also test the thingworx database and another imported database, they are all good in Thing->Services.
I am thinking if there is special requirements in the tablespace the database lying in? Or something else? I am still trying.
Solved. I use pgAdmin III to construct database. So the sql script need to use "", like select * from "TableName".
Retrieving data ...