I created this recently for another group - might be useful
Video Link to Create a Database connection to you Postgres Thingwork Database
Thank you, Steve
Short and clear.
This really helps to have such small tips - they are simple, but highlight different areas of Thingworx and give a basic understanding of where to start when one needs to implement some particular functionality.