On Mon, Jul 28, 2008 at 2:14 PM, G. Ralph Kuntz, MD, MS <grk / usa.net> wrote:
> I spent a couple of hour this weekend trying to get Ruby to talk to
> PostgreSQL on a Windows Vista machine without success. I am working
> with both Cygwin Ruby and JRuby.
>
> I installed the DBI gem, including dbd_pg. I get the following error
> in both version of Ruby:
>
>    Could not load driver (no such file to load -- /usr/lib/ruby/
> site_ruby/1.8/dbd/Pg)
>
> I also tried jruby-postgres and pgconn but I could not figure out how
> to call the first one and got errors with the  second. I could not
> find any documentation (even tried ri).
>
> I tried Googling everything I could think of.
>
> Has anyone gotten a DB connection to PostgreSQL working under Windows
> with any version of Ruby?
>
> Thanks.
>
>


Hi,

My current use of postgres is done like this (but I think you can
require 'dbi' instead of 'rubygems'):

require 'rubygems'
require 'postgres'

$conn = PGconn.connect('hostname','port','','','db-name','username','password')

If you've installed rails you can also do the following in order to
use  ActiveRecord which is nice:

require 'rubygems'
require 'active_record'
	
ActiveRecord::Base.pluralize_table_names = false
ActiveRecord::Base.establish_connection(
	:adapter		=>	"postgresql",
	:host		=>	"hostname",
	:database	=>	"db-name",
	:username	=>	"username",
	:password	=>	"password"
)

And then create objects of tables or views.
Assuming you have a table or a view called gen_table:

class GenTable < ActiveRecord::Base; end
gt = GenTable.find(:all)

for a in gt
    puts a.id
end



-- 
J-H Johansen
--
There are 10 kinds of people in the world: Those who understand binary and
those who don't...