Golang Postgres "LastInsertId is not supported by this driver"
When use golang connect to postgres, if you want to call LastInsertId
, you will get this error. But you can get the latest ID by another method. Use Returning
keyword to get the newest inserted ID. Just like below:
var id int
if err := db.QueryRow("INSERT INTO table(name) VALUES("xxxx") RETURNING ID").Scan(&id); err != nil {
panic(err)
}