from django.db import models from django.db import connection class BulkManager(models.Manager): def bulk_insert(self, fields, objs): qn = connection.ops.quote_name cursor = connection.cursor() flds = ', '.join([qn(f) for f in fields]) values_list = [ r[f] for r in objs for f in fields] arg_string = ', '.join([u'(' + ', '.join(['%s']*len(fields)) + ')'] * len(objs)) sql = "INSERT INTO %s (%s) VALUES %s" % (self.model._meta.db_table, flds, arg_string,) cursor.execute(sql, values_list)