Sorry, don't have an install of PostgreSQL handy to try. I think that this likely isn't included in DAL because of differing syntax and ability between the different databases and nobody having volunteered to sort it out and submit a patch. (For example i use MSSQL and such inserts are different between 2005 and 2008 versions)
I suppose you could let the DAL build the individual insert statements for you with db.mytable._insert(field1=a, field2=b) which you then store and then concatenate the individual insert statements into one big series of queries and run it via executesql(). That might work too. On Monday, August 12, 2013 9:38:45 AM UTC-5, ssuresh wrote: > > > Thanx Brian.. I too thought of something similar- concatenating to create > the sql ..Since executing multiple statements is quite common, I thought > something inbuilt will be there in web2py.. > > I dug through the code and found a executemany() function in gluon/ > contrib/pg8000/dbapi.py ..Will it serve the purpose? Is it accessible > through DAL > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
