connect to postgres (bmizerany/pq)

lib-pq.go

package main

import (
       	"database/sql"
       	"log"

       	_ "github.com/bmizerany/pq"
)

/* Database and User creation in psql

CREATE DATABASE testdb;
CREATE USER testuser WITH PASSWORD 'testpw';
GRANT ALL PRIVILEGES ON DATABASE testdb  TO testuser;

*/

func main() {
       	db, err := sql.Open("postgres", "dbname=testdb user=testuser password=testpw port=5432 sslmode=disable")
       	if err != nil {
       		log.Panic(err)
       	}
       	defer db.Close()

       	err = db.Ping()
       	if err != nil {
       		log.Panic(err)
       	}

       	log.Println("db.Ping() did not return an error, meaning database connection was established.")

}