Method: Sequel::Postgres::DatasetMethods#multi_insert_sql

Defined in:
lib/sequel/adapters/shared/postgres.rb

#multi_insert_sql(columns, values) ⇒ Object

For PostgreSQL version > 8.2, allow inserting multiple rows at once.



748
749
750
751
752
753
 
# File 'lib/sequel/adapters/shared/postgres.rb', line 748

def multi_insert_sql(columns, values)
  return super if server_version < 80200
  
  # postgresql 8.2 introduces support for multi-row insert
  [insert_sql(columns, LiteralString.new('VALUES ' + values.map {|r| literal(Array(r))}.join(COMMA_SEPARATOR)))]
end