func main() {
conninfo := "dbname=testdb"
conn := pg.Connect(conninfo)
status := pg.Status(conn)
fmt.Printf("conninfo=%s, status=%d\n", conninfo, status)
res := pg.Exec(conn, "select * from users;")
//res := pg.GetResult(conn);
fileds := pg.NFields(res)
fmt.Printf("fields = %d\n", fileds)
value := pg.GetValue(res, 0, 0)
fmt.Printf("value = %s\n", value)
pg.Close(conn)
}
func main() {
conninfo := "dbname=testdb"
conn := pg.Connect(conninfo)
status := pg.Status(conn)
fmt.Printf("conninfo=%s, status=%d\n", conninfo, status)
res := pg.Exec(conn, "select * from users;")
fileds := pg.NFields(res)
fmt.Printf("fields = %d\n", fileds)
value := pg.GetValue(res, 0, 0)
fmt.Printf("value = %s\n", value)
for {
row := pg.FetchRow(res)
if row == nil {
break
}
values := strings.Join(row, ",")
fmt.Printf("values = %s\n", values)
}
res = pg.Exec(conn, "select * from users;")
len := pg.GetLength(res, 0, 0)
fmt.Printf("length = %d\n", len)
fname := pg.FName(res, 0)
ftype := pg.FType(res, 0)
fnumber := pg.FNumber(res, "name")
fsize := pg.FSize(res, 0)
fmod := pg.FMod(res, 0)
fmt.Printf("fname=%s, ftype=%d, fnumber=%d, fsize=%d, fmod=%d\n",
fname, ftype, fnumber, fsize, fmod)
pg.Close(conn)
}