generated Keys

[GeoffOs]

apologies if this is incorrect...

Support on Execute for returning any generated keys as the result of statement. An example in Java would be:

Statement stmt = conn.createStatement();
stmt.execute(sql, Statement.RETURN_GENERATED_KEYS);
ResultSet keyset = stmt.getGeneratedKeys();

[lxn]

Hi Geoff,

You could do something like this if your table has a serial pk named id and you insert a single record:
...
var id int
_, err := conn.Scan("INSERT INTO foo (bar) VALUES ('baz') RETURNING id;", &id)
if err != nil {
return err
}
// do something with id
...

The Scan method is available on Conn as well as Statement.

If you insert multiple records at once, you may want to try one of the Query methods instead (didn't test this one though).

I'm closing this issue, but feel free to reopen, if it doesn't work out.

Thanks
Alex

[GeoffOs]

I did not know about that option in postgres.

Have got it working on your suggestion thanks.