How do I include postgresql username and password in the sql.Open command in golang? The below doesn't seem to work. Thanks!
func db() (database *sql.DB) {
database, err := sql.Open("postgres", "dbname=chitchat user=tom password=tomtom sslmode=disable")
if err != nil {
log.Fatal(err)
}
return
}
You can see examples in lib/pq/doc.go or murz/dat (which uses lib/pq):
db, err := sql.Open("postgres", "user=pqgotest dbname=pqgotest sslmode=verify-full")
db, err := sql.Open("postgres", "dbname=dat_test user=dat password=!test host=localhost sslmode=disable")
You can also connect to a database using a URL. For example:
db, err := sql.Open("postgres", "postgres://pqgotest:password@localhost/pqgotest?sslmode=verify-full")