Issue with bytea conversions

[sheldondz]

type Token struct {
    UserID.  string `json:"user_id" db:"user_id"`
    TokenID string `json:"token_id" db:"token_id"`
}

sqlQuery := "SELECT encode(token_id,'hex') from users"

var tokens []*Token
err := pgxscan.Select(ctx, db, &tokens, sqlQuery) 

Get the following error where token_id is bytea type

scanning all: scanning: scanning: doing scan: scanFn: scany: column: 'encode': no corresponding field found, or it's unexported

[georgysavva]

Hi. The problem here is that encode(token_id, 'hex') changes the column name from token_id to encode. So the solution is to explicitly set an alias in the SELECT statement:

sqlQuery := `SELECT encode(token_id,'hex') AS "token_id" from users`

Feel free to reopen the issue if you still have problems.