What is wrong with the script?

[tguo]

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?

Thanks!

[supandey]

Hi Tiantian, just to confirm did you save the Entity before testing the service?

[tguo]

Hi Sushant,

     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.

[tguo]

Solved. I use pgAdmin III to construct database. So the sql script need to use "", like select * from "TableName".

Finally...