I misunderstood the question. Anthony is correct there is the placeholder argument. What is missing is a way to specify the format of the parametric arguments according to http://www.python.org/dev/peps/pep-0249/ specs as handled by the parameterstyle attribute of pg8000:
*http://pybrary.net/pg8000/dbapi.html* You can pass parametric arguments but you cannot change the style these arguments are referred to in the SQL. Yet this is probably not too important. On Thursday, 6 September 2012 10:24:01 UTC-5, Massimo Di Pierro wrote: > > Not yet. There should be. > > On Thursday, 6 September 2012 09:38:29 UTC-5, Mike Girard wrote: >> >> 1. Is there a way to pass in parameters to the sql, in accordance with >> the psycopg2 recommendation? I don't see anything in the docstring about >> that. Does it matter? >> 2. Do the sql execution times reported by the toolbar include anything >> besides the execution time of the actual database query? Queries executed >> through web2py are taking 3 times longer or more than the same queries >> executed through PGadmin. They seem to be equally fast using psycopg2 via >> the python command line. >> > --
