Postgres DB CRUD

CRUD operation with Postgres Database. Install node-red-contrib-re-postgres from Manage Pallette.
Note: some third-party nodes may appear with blank styling, and not as they appear in the Node-RED Editor.
[{"id":"a45c03c1.b0bcb","type":"tab","label":"Database Interaction","disabled":false,"info":""},{"id":"40871504.e74a5c","type":"postgresdb","z":"","hostname":"ec2-35-173-94-156.compute-1.amazonaws.com","port":"5432","db":"d7jmq0cl6o4dki","ssl":true},{"id":"7bcf6756.3cee18","type":"ui_base","theme":{"name":"theme-light","lightTheme":{"default":"#0094CE","baseColor":"#0094CE","baseFont":"-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif","edited":true,"reset":false},"darkTheme":{"default":"#097479","baseColor":"#097479","baseFont":"-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif","edited":false},"customTheme":{"name":"Untitled Theme 1","default":"#4B7930","baseColor":"#4B7930","baseFont":"-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"},"themeState":{"base-color":{"default":"#0094CE","value":"#0094CE","edited":false},"page-titlebar-backgroundColor":{"value":"#0094CE","edited":false},"page-backgroundColor":{"value":"#fafafa","edited":false},"page-sidebar-backgroundColor":{"value":"#ffffff","edited":false},"group-textColor":{"value":"#1bbfff","edited":false},"group-borderColor":{"value":"#ffffff","edited":false},"group-backgroundColor":{"value":"#ffffff","edited":false},"widget-textColor":{"value":"#111111","edited":false},"widget-backgroundColor":{"value":"#0094ce","edited":false},"widget-borderColor":{"value":"#ffffff","edited":false},"base-font":{"value":"-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"}},"angularTheme":{"primary":"indigo","accents":"blue","warn":"red","background":"grey"}},"site":{"name":"Node-RED Dashboard","hideToolbar":"false","allowSwipe":"false","lockMenu":"false","allowTempTheme":"true","dateFormat":"DD/MM/YYYY","sizes":{"sx":48,"sy":48,"gx":6,"gy":6,"cx":6,"cy":6,"px":0,"py":0}}},{"id":"5efa0b4f.700054","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":80,"wires":[["7f62770c.08a308"]]},{"id":"7f62770c.08a308","type":"template","z":"a45c03c1.b0bcb","name":"Select List","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"SELECT * FROM public.\"userSettings\"\nORDER BY uuid ASC ","output":"str","x":470,"y":80,"wires":[["351af829.d00e78"]]},{"id":"351af829.d00e78","type":"postgres","z":"a45c03c1.b0bcb","postgresdb":"40871504.e74a5c","name":"Postgres","output":true,"perrow":false,"rowspermsg":"1","outputs":1,"x":720,"y":200,"wires":[["8d69a78e.94b188"]]},{"id":"8d69a78e.94b188","type":"debug","z":"a45c03c1.b0bcb","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":850,"y":200,"wires":[]},{"id":"30f70111.d70e4e","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":140,"wires":[["97618056.678e9"]]},{"id":"97618056.678e9","type":"function","z":"a45c03c1.b0bcb","name":"UUID = '123456'","func":"msg.queryParameters = msg.queryParameters || {};\nmsg.queryParameters.param1 = '123456';\nreturn msg;","outputs":1,"noerr":0,"x":260,"y":140,"wires":[["eda23294.7c1e4"]]},{"id":"eda23294.7c1e4","type":"template","z":"a45c03c1.b0bcb","name":"Select specific","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"SELECT * FROM public.\"userSettings\"\nwhere uuid = $param1","x":480,"y":140,"wires":[["351af829.d00e78"]]},{"id":"e2cab730.2fa698","type":"template","z":"a45c03c1.b0bcb","name":"Insert","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"INSERT INTO public.\"userSettings\"(message, appid, uuid) VALUES ($param2,$param3,$param1);","x":450,"y":200,"wires":[["351af829.d00e78"]]},{"id":"33ae867a.585a1a","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":200,"wires":[["db634814.32c078"]]},{"id":"db634814.32c078","type":"function","z":"a45c03c1.b0bcb","name":"UUID = '456789'","func":"msg.queryParameters = msg.queryParameters || {};\nmsg.queryParameters.param1 = '456789';\nmsg.queryParameters.param2 = 'Working';\nmsg.queryParameters.param3 = '654321';\nreturn msg;","outputs":1,"noerr":0,"x":260,"y":200,"wires":[["e2cab730.2fa698"]]},{"id":"9a6b8406.c8fd58","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":320,"wires":[["44208df8.ee8a34"]]},{"id":"2252008d.743b4","type":"template","z":"a45c03c1.b0bcb","name":"Update","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"UPDATE public.\"userSettings\"\n\tSET message=$param2\n\tWHERE uuid = $param1;","x":460,"y":320,"wires":[["351af829.d00e78"]]},{"id":"44208df8.ee8a34","type":"function","z":"a45c03c1.b0bcb","name":"Message = Updated","func":"msg.queryParameters = msg.queryParameters || {};\nmsg.queryParameters.param1 = '456789';\nmsg.queryParameters.param2 = 'Updated';\nreturn msg;","outputs":1,"noerr":0,"x":280,"y":320,"wires":[["2252008d.743b4"]]},{"id":"e918ab1e.eb11d8","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":380,"wires":[["78813d59.4290c4"]]},{"id":"3dc47522.ba464a","type":"template","z":"a45c03c1.b0bcb","name":"Delete","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"DELETE FROM public.\"userSettings\"\n\tWHERE uuid = $param1;","x":450,"y":380,"wires":[["351af829.d00e78"]]},{"id":"78813d59.4290c4","type":"function","z":"a45c03c1.b0bcb","name":"UUID = '456789'","func":"msg.queryParameters = msg.queryParameters || {};\nmsg.queryParameters.param1 = '456789';\nreturn msg;","outputs":1,"noerr":0,"x":260,"y":380,"wires":[["3dc47522.ba464a"]]},{"id":"384b69e6.3b0cf6","type":"template","z":"a45c03c1.b0bcb","name":"Insert Default","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"INSERT INTO public.\"userSettings\"(message, appid, uuid) VALUES ('Working','123456','987654');\nINSERT INTO public.\"userSettings\"(message, appid, uuid) VALUES ('Working','234567','876543');\nINSERT INTO public.\"userSettings\"(message, appid, uuid) VALUES ('Working','345678','765432');","x":470,"y":260,"wires":[["351af829.d00e78"]]},{"id":"c27a2c54.2d4e9","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":260,"wires":[["384b69e6.3b0cf6"]]},{"id":"82883ca0.d51ec","type":"inject","z":"a45c03c1.b0bcb","name":"Trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":110,"y":440,"wires":[["707fbb15.0ab194"]]},{"id":"707fbb15.0ab194","type":"template","z":"a45c03c1.b0bcb","name":"Delete All","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"DELETE FROM public.\"userSettings\";","x":460,"y":440,"wires":[["351af829.d00e78"]]}]