insert_data.sh脚本如下:
#!/bin/bash
psql -U uhxl -h localhost -d hxl << EOF
select sp_insert_data();
EOF
#pg生成测试数据
*/40 * * * * /home/postgres/scripts/insert_data.sh 1>/dev/null 2>&1
insert_data.sh脚本如下:
#!/bin/bash
psql -U uhxl -h localhost -d hxl << EOF
select sp_insert_data();
EOF
#pg生成测试数据
*/40 * * * * /home/postgres/scripts/insert_data.sh 1>/dev/null 2>&1