How do I get a list of column names from a psycopg2 cursor?
I would like a general way to generate column labels directly from the selected column names, and recall seeing that python’s psycopg2 module … Read more
psycopg2
psycopg2: insert multiple rows with one query
I need to insert multiple rows with one query (number of rows is not constant), so I need to execute query like this … Read more
SQLAlchemy: engine, connection and session difference
I use SQLAlchemy and there are at least three entities: engine, session and connection, which have execute method, so if I e.g. want … Read more
DatabaseError: current transaction is aborted, commands ignored until end of transaction block?
I got a lot of errors with the message : “DatabaseError: current transaction is aborted, commands ignored until end of transaction block” after … Read more
How to install psycopg2 with “pip” on Python?
I’m using virtualenv and I need to install “psycopg2”. I have done the following: pip install http://pypi.python.org/packages/source/p/psycopg2/psycopg2-2.4.tar.gz#md5=24f4368e2cfdc1a2b03282ddda814160 And I have the following messages: … Read more
pg_config executable not found
I am having trouble installing psycopg2. I get the following error when I try to pip install psycopg2: Error: pg_config executable not found. … Read more