go pg.go

gistfile1.go

package main

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

func main() {

    db,err := sql.Open("postgres","postgres://user:password@locahost:5432/database")                                                     
    if err != nil {
        log.Fatal(err)
    }   
    rows,err := db.Query("SELECT length($1) AS foo","hello")
    if err != nil {
        log.Print(err)
    }   

    var length int 
    for rows.Next() {
        err := rows.Scan(&length)
        if err != nil {
            log.Print(err)
            break
        }   
        log.Printf("length = %d",length)
    }   

    if rows.Err() != nil {
        log.Print(rows.Err())
    }   
}