Postgresql example from Ruby

require 'rubygems'
require 'postgres'
 
pg = PGconn.new('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
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0