[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