# Convert Flow from MySQL to PostgreSQL

**URL:** <https://discourse.nodered.org/t/convert-flow-from-mysql-to-postgresql/38730>\
**Category:** General\
**Created:** [7 January 2021 17:12 UTC](https://discourse.nodered.org/t/convert-flow-from-mysql-to-postgresql/38730 "2021-01-07T17:12:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Trocergian](https://avatars.discourse-cdn.com/v4/letter/t/d6d6ee/32.png) [@Trocergian](https://discourse.nodered.org/u/Trocergian)\
**Post date:** [7 January 2021 17:12 UTC](https://discourse.nodered.org/t/convert-flow-from-mysql-to-postgresql/38730/1 "2021-01-07T17:12:59Z")

</div>

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:

```auto
[{"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":""}]

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [8 March 2021 17:13 UTC](https://discourse.nodered.org/t/convert-flow-from-mysql-to-postgresql/38730/2 "2021-03-08T17:13:10Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.