insert json from mqtt into postgresql
[rtl433-sensors] / mqtt-pgsql.sh
1 #!/bin/sh -xe
2
3 mosquitto_sub -h 10.13.37.5 -t rpi2/rtl433/json | while read json ; do
4         echo $json > /dev/shm/rtl433.json
5         psql -c "copy rtl433 (json) from '/dev/shm/rtl433.json'" rot13
6 done