doupo5178 2018-03-28 04:22
浏览 278

在postgres jsonb数组中插入会导致json转义键和值-Golang pq

I am marshalling the data as

b, err := json.MarshalJSON(&u3)
    if err != nil {
        log.Println("error:", err)
    }

and then insert

INSERT INTO user_list (userid, listtype, data) VALUES ($1, $2, (array[$3::json]))

The data is written as

{"{\"from\": \"2010-11-12\", \"till\": \"2018-3-10\", \"oieId\": \"1212458454\", \"iType\": \"ird\"}"}

Nothing is helping me prevent those escaping from being written even though the data type is json.RawMessage.

Is there a way to just write as JSON and not cast the $3 to be cast to JSON or just prevent those escapes from being written to jsonb[] type row ?

Any help is appreciated. Thanks

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 西门子S7-Graph,S7-300,梯形图
    • ¥50 用易语言http 访问不了网页
    • ¥50 safari浏览器fetch提交数据后数据丢失问题
    • ¥15 matlab不知道怎么改,求解答!!
    • ¥15 永磁直线电机的电流环pi调不出来
    • ¥15 用stata实现聚类的代码
    • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
    • ¥20 docker里部署springboot项目,访问不到扬声器
    • ¥15 netty整合springboot之后自动重连失效
    • ¥15 悬赏!微信开发者工具报错,求帮改