func (rs *Rows) Scan to handle a column type of array string

Question

I have a column within my Postgres db for tags which is an array of strings.

I have it defined within a struct in my golang as:

type device struct {
    deviceID   string
    macAddress sql.NullString
    name       sql.NullString
    agentID    sql.NullString
    groupType  sql.NullString
    tags       []string

    normalized           bool
    normalizedName       string
    normalizedMacAddress string
}

When I run the scan on the rows as such:

            err = rows.Scan(&d.deviceID, &d.name, &d.tags, &d.macAddress, &d.agentID, &d.groupType)
        if err != nil {
            return nil, err
        }

It returns the following error:

"sql: Scan error on column index 2, name "tags": unsupported Scan...+55 more"

So what kinda of wrapper do I need for a string array in order to be an acceptable type?

user5728991 · Accepted Answer · 2019-03-18 17:25:28Z

5

Use pq.Array when scanning an array:

    err = rows.Scan(&d.deviceID, &d.name, pq.Array(&d.tags), &d.macAddress, &d.agentID, &d.groupType)
    if err != nil {
        return nil, err
    }

answered Mar 18, 2019 at 17:25

user5728991

Sign up to request clarification or add additional context in comments.

2 Comments

Will Over a year ago

would I need to change my original struct def?

user5728991 Over a year ago

No. Just call the function as shown in the answer.

Collectives™ on Stack Overflow

func (rs *Rows) Scan to handle a column type of array string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related