Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "fmt"
- "log"
- "database/sql"
- _ "github.com/lib/pq"
- )
- func main() {
- db, err := sql.Open(
- "postgres",
- "user=test password=test dbname=test sslmode=disable")
- if err != nil {
- log.Fatalf("error: %vn", err)
- }
- stmt, err := db.Prepare("INSERT INTO test(value) VALUES($1) RETURNING id")
- if err != nil {
- log.Fatalf("error: %vn", err)
- }
- var id int
- err = stmt.QueryRow("value to insert").Scan(&id)
- if err != nil {
- log.Fatalf("error: %vn", err)
- }
- fmt.Printf("inserted object's ID: %dn", id)
- }
- stmt, _ := connection.Prepare("INSERT ....")
- res, _ := stmt.Exec()
- id, err := res.LastInsertId()
Add Comment
Please, Sign In to add comment