gistfile1.go

package main

import (
	_ "github.com/bmizerany/pq"
	"database/sql"
	"log"
	"fmt"
)

func main() {
	db, err := sql.Open("postgres", "user=lee dbname=threedev sslmode=disable")
	defer db.Close()
	if err != nil {
		log.Fatal(err)
	}

	r, err := db.Query("SELECT id, firstname FROM users WHERE firstname IS NOT NULL")
	defer r.Close()
	if err != nil {
		log.Fatal(err)
	}

	if r.Next() {
		var id int
		var firstname string
		r.Scan(&id, &firstname)
		fmt.Printf("[%d] - %s\n", id, firstname)
	}
}