Differences

This shows you the differences between two versions of the page.

Link to this comparison view

postgresex [2014/10/26 01:52] (current)
Line 1: Line 1:
 +==== Postgresql example from Ruby ====
 +<code lang="​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'​))
 +}
 +
 +</​code>​
 +
 +----
 +  * [[rubyinfo|Back to Ruby]]
postgresex.txt ยท Last modified: 2014/10/26 01: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