I am using below goroutinue to inset record in PostgreSQL. After execution, I see records inserting twice. Any issue with below code ? can someone suggest.
func main() {
// create the statement string
var sStmt string = "INSERT INTO LOGINS (id,login_name,password) values ($1, $2,$3)"
psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+
"password=%s dbname=%s sslmode=disable",
host, port, user, password, dbname)
db, err := sql.Open("postgres", psqlInfo)
if err != nil {
log.Fatal(err)
}
stmt, err := db.Prepare(sStmt)
if err != nil {
log.Fatal(err)
}
fmt.Printf("StartTime: %v
", time.Now())
res, err := stmt.Exec(2000,"test","test")
fmt.Println("inserting")
if err != nil || res == nil {
log.Fatal(err)
}
stmt.Close()
db.Close()
fmt.Printf("StopTime: %v
", time.Now())
}