golang
package main
import _ "github.com/lib/pq"
func main() {
pgsqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+"password=%s dbname=%s sslmode=disable", host, port, user, password, dbname)
db, err := sql.Open("postgres", pgsqlInfo)
//fmt.Println(reflect.TypeOf(db)) //*sql.DB
err = db.Ping() //会将连接立马返回给连接池。
query_sql := "select * from tablename"
rows, err := db.Query(query_sql)
defer rows.Close()
}
package main
import _ "git