doutongxuan1614 2017-11-24 21:02
浏览 193
已采纳

Golang Postgresql数组

If I have a table that returns something like:

id: 1
names: {Jim, Bob, Sam}

names is a varchar array.

How do I scan that back into a []string in Go? I'm using lib/pg

Right now I have something like

rows, err := models.Db.Query("SELECT pKey, names FROM foo")
for rows.Next() {
            var pKey int
            var names []string
            err = rows.Scan(&pKey, &names)
}

I keep getting:

panic: sql: Scan error on column index 1: unsupported Scan, storing driver.Value type []uint8 into type *[]string

It looks like I need to use StringArray https://godoc.org/github.com/lib/pq#StringArray

But, I think I'm too new to Go to understand exactly how to use: func (a *StringArray) Scan(src interface{})

  • 写回答

1条回答 默认 最新

  • duanchong3075 2017-11-24 21:32
    关注

    You are right, you can use StringArray but you don't need to call the

    func (a *StringArray) Scan(src interface{})
    

    method yourself, this will be called automatically by rows.Scan when you pass it anything that implements the Scanner interface.

    So what you need to do is to convert your []string to *StringArray and pass that to rows.Scan, like so:

    rows, err := models.Db.Query("SELECT pKey, names FROM foo")
    for rows.Next() {
                var pKey int
                var names []string
                err = rows.Scan(&pKey, (*pq.StringArray)(&names))
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 有人能看一下我宿舍管理系统的报修功能该怎么改啊?链表那里总是越界
  • ¥15 cs loadimage运行不了,easyx也下了,没有用
  • ¥15 r包runway详细安装教程
  • ¥15 Html中读取Json文件中数据并制作表格
  • ¥15 谁有RH342练习环境
  • ¥15 STM32F407 DMA中断问题
  • ¥15 uniapp连接阿里云无法发布消息和订阅
  • ¥25 麦当劳点餐系统代码纠错
  • ¥15 轮班监督委员会问题。
  • ¥20 关于变压器的具体案例分析