Connect from Ruby to PostgreSQL

demo.rb

require 'pg'
require 'ap'

def connect(db, user, pw)
  PGconn.new('localhost', 5432, '', '', db, user, pw) 
end

def show_shops2(conn)
	conn.exec( "SELECT haendler_id AS id, * from tbl_haendler;" ) do |result|
		result.each  do |row|
		 puts " %7d | %s, %s, %s %s, %s => %s" % row.values_at('id', 'name','strasse', 'plz', 'ort','land', 'web')
		end
		result.each do |row|
			ap row
		end
	end
end

begin
  conn = connect('****','*','****')
  #show_movies(conn)
	show_shops2(conn)
rescue PGError=>e 
  puts "Eeeeeeeek!", e
ensure
  conn.close unless conn.nil?
  puts "Connection closed" 
end