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

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.