[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