Adapters for Numpy's types for Psycopg2.
psycopg2 does not ship with adapters for numpy's types and is unable to interpolate them in queries naturally.
Using numpy's values as parameters results in ProgrammingError: can't adapt type 'numpy.int32' and similar errors with other numpy types. Such errors are common while mixing numpy, pandas and psycopg2.
This package solves the problem by registering AsIs adapters for these types.
from psycopg2_numpy_ext import register_numpy_types register_numpy_types()
pip install git+git://github.com/musically-ut/psycopg2_numpy_ext.git@master#egg=psycopg2_numpy_ext
- numpy >= 1.9.2
- psycopg2 >= 2.5
psycopg2-numpy-ext was written by Utkarsh Upadhyay.