Creating data points for a postgresql data source
I created a data source on Mango successfully using postgresql connection. The table I am collecting data from is used to collect data from a historical database every 10 minutes and 300 data points. My next goal is to graph some of this data over time for specific point names. Where can I find the details on creating the data points for my source? I tried to follow the steps on video tutorials and help menu but that did not help.
Thanks,![0_1514389036978_postgresql database.png](Uploading 100%)
JoelHaggar last edited by
@eksantrik your photo did not upload. I think you need to wait a few moments after the upload is 100% until you see the photo display in the preview.
phildunlap last edited by
Might you happened to have seen my post in this thread: https://forum.infiniteautomation.com/topic/3115/sql-data-source-query/2
It may have some relevant information / inspiration.
The connection between the SQL points is the 'column name' on the point. If 'Row-based query' is not checked on your data source, then the point will get the value in the value column if its column name matches the ID column. If you are doing a row-based query, then it's the first selected column contains the identifier.