Golang Postgres connection string not opening return null

Question

I am sure that there is something with the connectionString as the values I am giving are the same values that I use in Java to log into the same database. This is my code

package main

import(
    "fmt"
    "database/sql"
    _ "github.com/lib/pq"

    "log"
)




func main() {


    db, err := sql.Open("postgres", "user=postgres password=password dbname=name sslmode=disable")

    if err != nil {
        log.Fatal(err)
    }

     defer db.Close()
    age := 21
    rows, err := db.Query("SELECT city FROM streams WHERE id=69", age)

    fmt.Println(rows)

}

I am using what I found here https://godoc.org/github.com/lib/pq my postgres version is 9.4 and my Go Version is 1.6 . I have no idea why it is happening.

Steve C · Accepted Answer · 2016-06-29 02:58:10Z

2

Could you add the ping code and see what error is returned?

package main

import (
    "fmt"
    "database/sql"
    _ "github.com/lib/pq"

    "log"
)

func main() {

    db, err := sql.Open("postgres", "user=postgres password=password dbname=name sslmode=disable")

    if err != nil {
        log.Fatal(err)
    }

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

    defer db.Close()
    age := 21
    rows, err := db.Query("SELECT city FROM streams WHERE id=$1", age)

    fmt.Println(rows)

}

answered Jun 29, 2016 at 2:58

Steve C

1,12411 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1591668 Over a year ago

Thank you it was the lack of the dollar sign that gave out the nil.

dmitryro · Accepted Answer · 2016-06-29 02:53:14Z

1

Your

 rows, err := db.Query("SELECT city FROM streams WHERE id=69", age)

has to be:

 rows, err := db.Query("SELECT city FROM streams WHERE id = ?", age)

also

 defer db.Close()

goes after you execute the query.

answered Jun 29, 2016 at 2:53

dmitryro

3,5162 gold badges23 silver badges30 bronze badges

1 Comment

user1591668 Over a year ago

Thank you that helped towards the answer.

Collectives™ on Stack Overflow

Golang Postgres connection string not opening return null

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related