I am doing some basic SQL queries in my rails console. When I query my postgreSQL database, the result is a PG Result object as seen here:
#<PG::Result:0x007f26cac82010 status=PGRES_TUPLES_OK ntuples=1 nfields=1 cmd_tuples=1>
sql = "SELECT COUNT (DISTINCT Business_id) FROM applications"
result = ActiveRecord::Base.connection.execute(sql)
The PGResult object has some special methods for retrieving the results, the 'getvalue' method returns the tuple n as a hash, so then you could do:
More detailed information can be found here here: