更新的时候,一个json字符串作为插入参数,字符串: '{"sn":"1131","mac":"1121"}' ,函数:json_to_record
UPDATE terminal
set
device_sn=a.sn,
device_mac=a.mac
from json_to_record('{"sn":"1131","mac":"1121"}'::json) as a
(
sn text, mac text
)
WHERE
id=1
批量插入数据用: json_to_recordset, 字符串: '[{"sn":"1131","mac":"1121"},{"sn":"12","mac":"21"}]'
INSERT INTO terminal (sn,mac)
select sn,mac
from json_to_recordset(_s_json_parms::json) as a
( sn text,mac text)