I have an staging table "test1" created in Postgresql v9.6 which has all the other tables under a column <tablename>. I wanted to select all data from another table through the staging table "test1".
I used a query SELECT * FROM (SELECT tableName FROM public."Test1" where id='1')
How can I solve this? Please provide some help.
Solved! Go to Solution.
You indicated you were trying to query PostgreSQL 9.6. Is this your model provider or are you using it as a data provider? This version is not supported if using as the model provider for ThingWorx.
Could you provide the error message you are getting? Have you checked the logs for more information regarding the failure? Is your query being executed in ThingWorx or are you running this in PostgreSQL?
Hi slangley ,
Thanks for your response.
I am trying to execute this in Postgres and now I have upgraded to 8.2 version of ThingWorx and so using Postgres 9.4. And what is the model provider and data provider? are you reffering to external plug in or the persistence provider?
If the previous response answered your questions, please mark it as the Accepted Solution for the benefit of others with the same questions.