postgresql使用uuid作为主键

INSERT INTO tb_charger_heartbeat
(id, charger_id, gun_no, gun_status, create_time)
VALUES
(gen_random_uuid(), @chargerCode, @gunNo, @gunStatus, now());

gen_random_uuid()需要扩展：

CREATE EXTENSION IF NOT EXISTS pgcrypto;