title: python psycopg2 - ProgrammingError: function crosstab(unknown, unknown) does not exist
body: <p>I would like to execute an SQL query which has crosstab function in Python, however I get this error message:</p>
  
  <blockquote>
    <p>psycopg2.ProgrammingError: function crosstab(unknown, unknown) does not exist
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.</p>
  </blockquote>
  
  <p>Is there a workaround? I already tried upgrading psycopg2 (pip install psycopg2 --upgrade).
  Thanks a lot</p>