Python to Postgres interface with real prepared statements?

Question

I've been trying to find a postgres interface for python 2.x that supports real prepared statements, but can't seem to find anything. I don't want one that just escapes quotes in the params you pass in and then interpolates them into the query before executing it. Anyone have any suggestions?

Answer 1

have a look at web.py's db module

examples can be found at

1. http://webpy.org/cookbook/select
2. http://webpy.org/cookbook/update
3. http://webpy.org/cookbook/delete
4. http://webpy.org/Insert

Answer 2

Either py-postgresql for Python3 or pg_proboscis for Python2 will do this.

Python-pgsql will also do this but is not threadsafe. Notably, SQLAlchemy does not make use of prepared statements.