postgres example using lib/pq

[will]

Hi, 

Can someone give me a basic example of pulling data from a postgres database e.g. mydatabase for two parameters, firstname, lastname. Example to use using lib/pq.

Regards,

Will

[Geoffrey Teale]

Top tip Will - if you can't find docs for a project, look at the unit
tests - in the source of lib/pq you can start with conn_test.go - it's
go then basics all there.

Regards,
Geoff Teale

> --
> You received this message because you are subscribed to the Google Groups
> "golang-nuts" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to golang-nuts...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.

[will]

Through Help from Rob(inbox email) i was able to make it work:

package main

import (

"fmt"

_ "github.com/lib/pq"

"database/sql"

)

var selectStatement = `

select firstname, lastname from contacts limit 10

`

func main() {

fmt.Printf("testing..\n")

var db *sql.DB

var err error

db, err = sql.Open("postgres", "user=robinson dbname=crusoe host=localhost password=island123")

if err != nil {

fmt.Printf("sql.Open error: %v\n",err)

return

}

defer db.Close()

err = doSelect(db)

if err != nil {

fmt.Printf("select error: %v\n",err)

return

}

}

func doSelect(db *sql.DB) error {

var stmt *sql.Stmt

var err error

stmt, err = db.Prepare(selectStatement)

if err != nil {

fmt.Printf("db.Prepare error: %v\n",err)

return err

}

var rows *sql.Rows

rows, err = stmt.Query()

if err != nil {

fmt.Printf("stmt.Query error: %v\n",err)

return err

}

defer stmt.Close()

for rows.Next() {

var firstname string

var lastname string

err = rows.Scan(&firstname, &lastname)

if err != nil {

fmt.Printf("rows.Scan error: %v\n",err)

return err

}

fmt.Printf("firstname: %v lastname: %v \n",

firstname, lastname);

}

return nil

}

thanks Rob once again

[atkaaz]

when you say:

"Through Help from Rob(inbox email) i was able to make it work:"

I am assuming that Rob actually wanted to send the reply to the group but it was sent to only your email, because of this:
https://groups.google.com/d/msg/golang-nuts/ynwTqc20vCI/izo7OkeVNrIJ

--

[Rob Lapensee]

no, that was not it,

I just sent Will a wee program directly that I wrote in go that has the basic SQL operations (insert, select, etc.) using one of the postgresql drivers.

It seemed the thing to do to get him going quickly.

The program was written before I knew Go as well as I do now.

If anyone is interested I can fix it up, go format it, and post it, but I know there are other examples already available.

Regards,

Rob

[atkaaz]

Ok, thanks Rob. I assumed wrongly.

[abdulr...@googlemail.com]

excellent. thanks. a time saver.

[arbin...@gmail.com]

Here's a nice succinct example http://albertech.blogspot.com/2016/10/minimal-sql-select-example-for-go-and.html