Advertisement
Guest User

Untitled

a guest
Oct 20th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. package main
  2.  
  3. import (
  4. "database/sql"
  5. "fmt"
  6.  
  7. "strings"
  8. "time"
  9.  
  10. _ "github.com/lib/pq"
  11. )
  12.  
  13. func main() {
  14. var err error
  15. db, err := sql.Open("postgres", "host=localhost port=5433 user=admin password=Oma524744 dbname=Role sslmode=disable")
  16. if err != nil {
  17. fmt.Println("Postgresql not found!:", err)
  18. }
  19.  
  20. if err = db.Ping(); err != nil {
  21. fmt.Println("Postgresql not reply!:", err)
  22. }
  23. Results := make([]string, 0)
  24. Rows, err := db.Query("SELECT "Name" FROM "Test" WHERE id=$1;", 1)
  25. for Rows.Next() {
  26. var tmp string
  27. Rows.Scan(&tmp)
  28. t1 := time.Now()
  29. tmp = tmp[1 : len(tmp)-1]
  30. fmt.Println(tmp)
  31. Results = strings.Split(tmp, ",")
  32. t2 := time.Now()
  33. fmt.Println("::->", t2.Sub(t1).Nanoseconds())
  34. }
  35. for _, v := range Results {
  36. fmt.Println(v)
  37. }
  38. if err != nil {
  39. fmt.Println(err)
  40. }
  41.  
  42. }
  43.  
  44. CREATE TABLE "Test"
  45. (
  46. id integer,
  47. "Name" numeric[]
  48. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement