postgres

gem 'pg'
require 'pg'
 def with_db
   db = PG.connect(
     dbname: 'dbname',
     user: 'user',
     password: 'password'
   )
   begin
      yield db
   ensure
      db.close
   end
 end

sql = File.open('path/to/your_sql.sql', 'rb') { |file| file.read }
with_db do |db|
  begin
    db.exec(sql)
  rescue PG::Error
     #####
  end
end