Postgresql example from Ruby

require 'rubygems'
require 'postgres'
pg ='localhost',5432,nil,nil,'dbName','root')
res = pg.exec("select * from myTable")
# to check number of rows returned 
puts res.num_tuples
# to extract a field (name) from every row
(1..res.num_tuples.to_i).each { |rownum|
    puts res.getvalue(rownum, res.fieldnum('name'))

postgresex.txt · Last modified: 2014/10/25 21:52 (external edit)
CC Attribution-Share Alike 3.0 Unported Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0