I'm trying to convert this flow from using a MySQL database over to a PostgreSQL database and not having much luck.
Full disclosure: I didn't create the MySQL flow so much as copied it from a "How to " book. I did have to tweak it a bit, but it works fine as is.
Any help would be greatly appreciated.
Here's the MySQL flow:
[{"id":"6bc25fe.ca060a","type":"http in","z":"73f1e274.40322c","name":"","url":"/jsonin","method":"post","upload":false,"swaggerDoc":"","x":150,"y":160,"wires":[["12a680d0.c4553f"]]},{"id":"12a680d0.c4553f","type":"function","z":"73f1e274.40322c","name":"Create Query","func":"var strQuery = \"INSERT INTO tblPrime (DateTimeStamp, UnitName, CPU, StatusRep, ErrReport, TC1, TC2, TC3, TC4, TC5, TC6, TC7, TC8,\" +\n \"AIN0, AIN1, AIN2, AIN3, AIN4, AIN5, AIN6, AIN7, DIN0, DIN1, DIN2, DIN3, DIN4, DIN5, DIN6, DIN7)\" +\n \"VALUES ('\" + msg.payload.DateTimeStamp + \"','\" + msg.payload.UnitName + \"','\" + msg.payload.CPU + \"','\" + msg.payload.StatusRep + \"','\" + msg.payload.ErrReport + \"',\" +\n \"'\" + msg.payload.TC1 + \"','\" + msg.payload.TC2 + \"','\" + msg.payload.TC3 + \"','\" + msg.payload.TC4 + \"',\" +\n \"'\" + msg.payload.TC5 + \"','\" + msg.payload.TC6 + \"','\" + msg.payload.TC7 + \"','\" + msg.payload.TC8 + \"',\" +\n \"'\" + msg.payload.AIN0 + \"','\" + msg.payload.AIN1 + \"','\" + msg.payload.AIN2 + \"','\" + msg.payload.AIN3 + \"',\" +\n \"'\" + msg.payload.AIN4 + \"','\" + msg.payload.AIN5 + \"','\" + msg.payload.AIN6 + \"','\" + msg.payload.AIN7 + \"',\" +\n \"'\" + msg.payload.DIN0 + \"','\" + msg.payload.DIN1 + \"','\" + msg.payload.DIN2 + \"','\" + msg.payload.DIN3 + \"',\" +\n \"'\" + msg.payload.DIN4 + \"','\" + msg.payload.DIN5 + \"','\" + msg.payload.DIN6 + \"','\" + msg.payload.DIN7 + \"');\";\n\nmsg.topic = strQuery;\n\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":370,"y":160,"wires":[["842ced20.e8574"]]},{"id":"842ced20.e8574","type":"mysql","z":"73f1e274.40322c","mydb":"c2cce60a.385088","name":"","x":580,"y":160,"wires":[["8ba6663a.ccdaf8","f4a9bdf6.51b85"]]},{"id":"8ba6663a.ccdaf8","type":"http response","z":"73f1e274.40322c","name":"","statusCode":"","headers":{},"x":830,"y":120,"wires":[]},{"id":"f4a9bdf6.51b85","type":"debug","z":"73f1e274.40322c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":850,"y":200,"wires":[]},{"id":"c2cce60a.385088","type":"MySQLdatabase","z":"","name":"","host":"127.0.0.1","port":"3306","db":"SpiralxPrime","tz":""}]
