如何在jsonb字段中插入map[string]

package main

import (
    "database/sql"
    "encoding/json"
    "fmt"

    _ "github.com/lib/pq"
)

type Data struct {
    JSONBField map[string]interface{} `json:"jsonb_field"`
}

func main() {
    // 连接到数据库
    db, err := sql.Open("postgres", "host=localhost port=5432 user=your_user password=your_password dbname=your_db sslmode=disable")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    // 创建一个map[string]
    myMap := make(map[string]interface{})
    myMap["key1"] = "value1"
    myMap["key2"] = 123
    myMap["key3"] = true

    // 将map[string]转换为JSON字符串
    jsonData, err := json.Marshal(myMap)
    if err != nil {
        panic(err)
    }

    // 创建Data结构体并设置JSONB字段的值
    data := Data{
        JSONBField: make(map[string]interface{}),
    }
    err = json.Unmarshal(jsonData, &data.JSONBField)
    if err != nil {
        panic(err)
    }

    // 将Data结构体插入到数据库中
    _, err = db.Exec("INSERT INTO your_table (jsonb_column) VALUES ($1)", data)
    if err != nil {
        panic(err)
    }

    fmt.Println("插入成功！")
}