使用数组字段将postgres行转换为golang结构

type MyStruct struct {
    Field1 string
    Field2 int
    Field3 []string
    // 其他字段...
}

SELECT field1, field2, field3 FROM my_table WHERE ...

rows, err := db.Query("SELECT field1, field2, field3 FROM my_table WHERE ...")
if err != nil {
    // 处理错误
}
defer rows.Close()

var results []MyStruct
for rows.Next() {
    var field1 string
    var field2 int
    var field3 []string
    err := rows.Scan(&field1, &field2, pq.Array(&field3))
    if err != nil {
        // 处理错误
    }
    result := MyStruct{
        Field1: field1,
        Field2: field2,
        Field3: field3,
    }
    results = append(results, result)
}
if err = rows.Err(); err != nil {
    // 处理错误
}