package main

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

    _ "github.com/lib/pq"
)

func main() {
    db, err := sql.Open("postgres", "postgres://user:pass@localhost/app?sslmode=disable")
    if err != nil { log.Fatal(err) }
    defer db.Close()

    rows, err := db.Query("SELECT id, name FROM users WHERE active = $1", true)
    if err != nil { log.Fatal(err) }
    defer rows.Close()

    for rows.Next() {
        var id int
        var name string
        rows.Scan(&id, &name)
        fmt.Printf("%d %s\n", id, name)
    }
}