Unmarshal Postgresql's json type in Go

pg-json-select.go

package main

import (
	"database/sql"
	"encoding/json"
	"fmt"
	"log"

	_ "github.com/lib/pq"
)

func main() {
	db, err := sql.Open("postgres", "user=artyom dbname=artyom sslmode=disable")
	if err != nil {
		log.Fatal(err)
	}
	var buf []byte
	if err := db.QueryRow(query).Scan(&buf); err != nil {
		log.Fatal(err)
	}
	var items []int
	if err := json.Unmarshal(buf, &items); err != nil {
		log.Fatal(err)
	}
	fmt.Printf("%#v\n", items)
}

const query = `select '[1,2,3]'::json as foo`