Top "Psycopg2" questions

Psycopg is a PostgreSQL adapter for Python programming language.

InternalError: current transaction is aborted, commands ignored until end of transaction block

I'm getting this error when doing database calls in a sub process using multiprocessing library. Visit : Pastie InternalError: current transaction …

python postgresql multiprocessing psycopg2 web.py
How do I run psycopg2 on El Capitan without hitting a libssl error

I've got a python django dev setup on my mac and have just upgraded to El Capitan. I've got psycopg2 …

python psycopg2 osx-elcapitan libssl
How to use server side cursors with psycopg2

I have a table with 4million rows and I use psycopg2 to execture a: SELECT * FROM ..WHERE query I haven't …

python postgresql cursor psycopg2
How to setup django-hstore with an existing app managed by south?

I tried to use django-hstore using this nice tutorial. I added two classes to an existing app managed by South: …

python django psycopg2 hstore
Cannot install "psycopg2" on Windows 10 with Python 3.8

Yesterday I uninstalled python 3.7 version by mistake. Then I install python again (this time 3.8 version) and again set up my …

django postgresql psycopg2 python-3.8
Django, mod_wsgi, psycopg2 ImproperlyConfigured: Error loading psycopg2 module: No module named _psycopg

I have a Django 1.5, Python 2.7 site running under Apache with mod_wsgi on a CentOS 6.4 server. I have rebuilt this …

django apache postgresql psycopg2 centos6
Exporting a PostgreSQL query to a csv file using Python

I need to export some rows from a table in a PostgreSQL database to a .csv file using a Python …

python sql postgresql export-to-csv psycopg2
Python error: execute cannot be used while an asynchronous query is underway

How do I prevent the error “ProgrammingError: execute cannot be used while an asynchronous query is underway”? From the docs …

python psycopg2 gevent
getting error when installing psycopg2==2.8.1

Very much brand new to this and trying to learn from a tut, I'm trying to install dependencies for a …

python psycopg2 pipenv
Psycopg2 uses up memory on large select query

I am using psycopg2 to query a Postgresql database and trying to process all rows from a table with about 380…

python postgresql psycopg2