insert json from mqtt into postgresql

diff --git a/mqtt-pgsql.sh b/mqtt-pgsql.sh
new file mode 100755 (executable)
index 0000000..c0d56fa
--- /dev/null
+++ b/mqtt-pgsql.sh
@@ -0,0 +1,6 @@
+#!/bin/sh -xe
+
+mosquitto_sub -h 10.13.37.5 -t rpi2/rtl433/json | while read json ; do
+       echo $json > /dev/shm/rtl433.json
+       psql -c "copy rtl433 (json) from '/dev/shm/rtl433.json'" rot13
+done