#!/usr/bin/env ruby

$KCODE = 'e'

require 'pg'
pg = PGconn.new(:dbname=>'ta05001', :user=>'postgres',:port=>5432)

sql =  'select * from position;'
result = pg.exec(sql)

result.each{|i| p i}

result.clear
pg.close