Get the id of a newly inserted record using 'pg' gem

Question

I'm using the 'pg' gem to work with postgresql from ruby. When inserting a new record, how can I get its serial id?

DB = PG.connect dbname: 'mydb', user: 'myuser'
res = DB.exec "insert into ..."

Answer 1

I've found out you can add returning id to the query string. I.e.

DB = PG.connect dbname: 'mydb', user: 'myuser'
res = DB.exec "insert into ..."
id = res.first['id']

Source