Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "database/sql"
- "fmt"
- "strings"
- "time"
- _ "github.com/lib/pq"
- )
- func main() {
- var err error
- db, err := sql.Open("postgres", "host=localhost port=5433 user=admin password=Oma524744 dbname=Role sslmode=disable")
- if err != nil {
- fmt.Println("Postgresql not found!:", err)
- }
- if err = db.Ping(); err != nil {
- fmt.Println("Postgresql not reply!:", err)
- }
- Results := make([]string, 0)
- Rows, err := db.Query("SELECT "Name" FROM "Test" WHERE id=$1;", 1)
- for Rows.Next() {
- var tmp string
- Rows.Scan(&tmp)
- t1 := time.Now()
- tmp = tmp[1 : len(tmp)-1]
- fmt.Println(tmp)
- Results = strings.Split(tmp, ",")
- t2 := time.Now()
- fmt.Println("::->", t2.Sub(t1).Nanoseconds())
- }
- for _, v := range Results {
- fmt.Println(v)
- }
- if err != nil {
- fmt.Println(err)
- }
- }
- CREATE TABLE "Test"
- (
- id integer,
- "Name" numeric[]
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement