[Tutor] Executing Store Procedures using PygreSQL
Danny Yoo
dyoo at hkn.eecs.berkeley.edu
Sun Aug 31 02:32:03 EDT 2003
On Sat, 30 Aug 2003, Peter Brown wrote:
> Hi list,
>
> I've been searching for a reference to executing stored procedures via a
> select call without luck.
Hi Peter,
According to:
http://www.python.org/peps/pep-0249.html
you can call a stored procedure by using the 'callproc()' method of your
cursor. PyGreSQL should support it, as it's part of the DB-API 2.0
standard. Unfortunately, I don't have enought experience with PostGreSQL
to test this out; can someone confirm that callproc() works with PyGreSQL?
Good luck to you!
More information about the Tutor
mailing list