Skip to content

Instantly share code, notes, and snippets.

View railsfactory-kumaresan's full-sized avatar

Kumaresan railsfactory-kumaresan

0 followers · 11 following
View GitHub Profile
@ged
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;