@PP_10265536
Just to clarify, you want to enter a SQL query as text into a mashup and execute that query on a Postgresql database?
If so, I would not recommend letting a user enter raw sql into a mashup to have it executed directly on a DB due to the numerous ways that somebody either maliciously or accidentally could mess up your database. I always wrap my database services in a JavaScript service and hide the implementation from the users.
With that said, if you really need to accomplish this, you'll need to:
1. Set up a DatabaseThing that connects to your database
2. Create a service that takes an input called myQuery (or whatever you want)
3. The code of the service will just be:
<<myQuery>>
4. In your mashup, you'll just have a Grid widget that you can show the result in.
Hope that helps,
Nick
