Kumaresan railsfactory-kumaresan

ged / copyfrom.rb

Created September 28, 2010 15:45

Example of how to use COPY FROM from Ruby with the 'pg' library. The last two edits are demonstrating the error case and the successful case.

	#!/usr/bin/env ruby

	require 'pg'
	require 'stringio'

	$stderr.puts "Opening database connection ..."
	conn = PGconn.connect( :dbname => 'test' )

	conn.exec( <<END_SQL )
	DROP TABLE IF EXISTS logs;