将golang切片直接插入postgres数组

import (
    "database/sql"
    _ "github.com/lib/pq"
)

db, err := sql.Open("postgres", "host=your_host port=your_port user=your_user password=your_password dbname=your_db sslmode=disable")
if err != nil {
    // 处理连接错误
}
defer db.Close()

data := []int{1, 2, 3, 4, 5}

array := "{" + strings.Trim(strings.Replace(fmt.Sprint(data), " ", ",", -1), "[]") + "}"

stmt, err := db.Prepare("INSERT INTO your_table (your_array_column) VALUES ($1)")
if err != nil {
    // 处理准备语句错误
}
defer stmt.Close()

_, err = stmt.Exec(array)
if err != nil {
    // 处理执行语句错误
}