OK, here are some more details...
My PostgreSQL table:
The Flow I used based on the example provided
[{"id":"a719ec3f.5e1e9","type":"tab","label":"Flow 3","disabled":false,"info":""},{"id":"9db08151.9b72e","type":"inject","z":"a719ec3f.5e1e9","name":"trigger","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":"","topic":"","payload":"","payloadType":"date","x":150,"y":140,"wires":[["e4e62dfc.b9685"]]},{"id":"90234c95.12b99","type":"template","z":"a719ec3f.5e1e9","name":"format query","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"select * from measurement where numeric_value > $param1","x":553,"y":138,"wires":[["bcb21762.870678","e1c9f296.68ee7"]]},{"id":"bcb21762.870678","type":"postgres","z":"a719ec3f.5e1e9","postgresdb":"47c2ceaa.9ce9b","name":"","output":true,"perrow":false,"rowspermsg":"1","outputs":1,"x":720,"y":134,"wires":[["b9fb2278.0a17f"]]},{"id":"a37e5920.3aaab8","type":"debug","z":"a719ec3f.5e1e9","name":"query output","active":false,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":950,"y":240,"wires":[]},{"id":"599b2e8d.55434","type":"http request","z":"a719ec3f.5e1e9","name":"","method":"POST","ret":"txt","url":"http://localhost:1880/incoming_data","x":530,"y":500,"wires":[["43322974.6b14d8"]]},{"id":"43322974.6b14d8","type":"debug","z":"a719ec3f.5e1e9","name":"http result","active":false,"console":"false","complete":"payload","x":713,"y":500,"wires":[]},{"id":"e4e62dfc.b9685","type":"function","z":"a719ec3f.5e1e9","name":"setup params","func":"msg.queryParameters = msg.queryParameters || {};\nmsg.queryParameters.param1 = 1000;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":353,"y":136,"wires":[["90234c95.12b99"]]},{"id":"e1c9f296.68ee7","type":"debug","z":"a719ec3f.5e1e9","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":610,"y":260,"wires":[]},{"id":"b9fb2278.0a17f","type":"json","z":"a719ec3f.5e1e9","name":"","property":"payload","action":"","pretty":false,"x":910,"y":140,"wires":[["a37e5920.3aaab8"]]},{"id":"47c2ceaa.9ce9b","type":"postgresdb","z":"a719ec3f.5e1e9","hostname":"localhost","port":"5432","db":"testdb2","ssl":false}]
Thank you