Result from ActiveRecord::Base.connection.execute(sql) - PostgreSQL

Question

How can I find number of records processed by PostgreSQL after executing a SQL statement using ActiveRecord::Base Connection class?

temp_sql = "UPDATE table_a SET column_a ='abc' WHERE column_b = 1"
result = ActiveRecord::Base.establish_connection(@db).connection.execute(temp_sql)

Or can you suggest better way to do this. Please keep in mind that above update statement is a simple one to keep question brief. My real queries are "set based" and involves complex create temp tables, update, insert statements.

Answer 1

Found the answer in PG::Result class. It is cmd_tuples method;

temp_sql = "UPDATE table_a SET column_a ='abc' WHERE column_b = 1"
result = ActiveRecord::Base.establish_connection(@db).connection.execute(temp_sql)
number_of_records = result.cmd_tuples