Top "Psycopg2" questions

psycopg2 not actually inserting data

I need to insert JSON data from tornado to postgres, so here's test like this: from psycopg2 import connect conn = …

python postgresql psycopg2

Install pip on pypy

I want to speed up my program so i'm trying to setup pypy + psycopg2cffi. This program opens a xml, …

python pip psycopg2 pypy

SQLAlchemy or psycopg2?

I am writing a quick and dirty script which requires interaction with a database (PG). The script is a pragmatic, …

python postgresql sqlalchemy psycopg2

psycopg2: AttributeError: 'module' object has no attribute 'extras'

In my code I use the DictCursor from psycopg2.extras like this dict_cur = conn.cursor(cursor_factory=psycopg2.extras.…

python psycopg2 importerror

Escape SQL "LIKE" value for Postgres with psycopg2

Does psycopg2 have a function for escaping the value of a LIKE operand for Postgres? For example I may want …

python postgresql psycopg2 python-db-api

Operational Error: FATAL: database "django" does not exist

I'm a db dummy, and im trying to set up PostgreSQL for my django project. For that I also use …

django database postgresql psycopg2

use try/except with psycopg2 or "with closing"?

I'm using Psycopg2 in Python to access a PostgreSQL database. I'm curious if it's safe to use the with closing() …

python postgresql psycopg2

Passing list of parameters to SQL in psycopg2

I have a list of ids of rows to fetch from database. I'm using python and psycopg2, and my problem …

python postgresql psycopg2

Setting schema for all queries of a connection in psycopg2: Getting race condition when setting search_path

Our system is running on Ubuntu, python 3.4, postgres 9.4.x and psycopg2. We (will in the furture) split between dev, test …

python postgresql python-3.x schema psycopg2

How to find psycopg2 version number

I installed psycopg2 on my Ubuntu Natty machine using apt-get. Now, I would like to know its version number. Can …

python psycopg2