[postmodern-devel] Multirow inserts and transactions in postmodern

Harry Bock harry at oshean.org
Tue Nov 11 18:39:40 UTC 2008


Hi,

I'm wonder what the proper :insert-into syntax would be to insert
multiple rows simultaneously, like so:

"INSERT INTO my_table (col1, col2, col3) VALUES
  ('1', '2', '3'),
  ('4', '5', '6'),
  ...;"

As this tends to be much faster when inserting large data sets.

Also, the transaction functionality of postmodern doesn't seem to be
well-documented. Is the only method of working with them to wrap calls
in the with-transaction macro?

Thanks,
Harry

-- 
Harry Bock
Software Developer, Package Maintainer
OSHEAN, Inc.
Email: harry at oshean.org
PGP Key ID: 546CC353





More information about the postmodern-devel mailing list