psycopg2
using list to input data using psycoyg2 python (with missing data)
Want to get data with some missing values from cvs into postgresql. I am happy to insert using strings. I would like a fast was to do this using list or something similer. I also need to check for mis[详细]
2023-01-28 19:52 分类:问答question about postgresql bind variables
I was looking at the question and decided to try using the bind variables. I use sql = \'insert into abc2 (interfield,textfield) values (%s,%s)\'[详细]
2023-01-26 09:45 分类:问答Psycopg / Postgres : Connections hang out randomly
I\'m using psycopg2 for the cherrypy app I\'m currently working on and cli & phpgadmin to handle some operations manually. Here\'s the python code :[详细]
2023-01-25 11:59 分类:问答ImportError: cannot import name tz (psycopg2)
I am using Windows XP, and using Python run time from http://www.python.org/ftp/python/2.7/python-2.7.msi[详细]
2023-01-25 11:24 分类:问答How to have data structure with both tuple and dictionary characteristic
By refering code at http://initd.org/psycopg/docs/extras.html#dictionary-like-cursor >>> rec[\'data\'][详细]
2023-01-24 13:25 分类:问答psycopg2 to deal with timestamp without time zone
I obtain a record from PostgreSQL, which its type is timestamp without time zone I am using psycopg2 I might get datetime object if I am using timestamp with time zone. But, currently, this is not t[详细]
2023-01-24 07:11 分类:问答Python, Django and Threading problem
Greetings, Under django 1.2 and Postgresql via psycopg2, I have a custom command that does heavy database actions (via Django ORM). I wrote it with threat pool via using the code here[详细]
2023-01-23 21:10 分类:问答Is it possible to issue a "VACUUM ANALYZE <tablename>" from psycopg2 or sqlalchemy for PostgreSQL?
Well, the question pretty much summarises it. My db activ开发者_如何转开发ity is very update intensive, and I want to programmatically issue a Vacuum Analyze. However I get an error that says that the[详细]
2023-01-19 19:42 分类:问答Installing psycopg2 in virtualenv (Ubuntu 10.04, Python 2.5)
I had problems installing psycopg2 in a virtualenv. I tried different things explained there: http://www.saltycrane.com/blog/2009/07/using-psycopg2-virtualenv-ubuntu-jaunty/[详细]
2023-01-18 07:05 分类:问答psycopg2 equivalent of mysqldb.escape_string?
I\'m passing some v开发者_如何学Calues into a postgres character field using psycopg2 in Python. Some of the string values contain periods, slashes, quotes etc.[详细]
2023-01-17 22:28 分类:问答