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
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)\'
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 :
I am using Windows XP, and using Python run time from http://www.python.org/ftp/python/2.7/python-2.7.msi
By refering code at http://initd.org/psycopg/docs/extras.html#dictionary-like-cursor >>> rec[\'data\']
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
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
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
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/
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.
加载中,请稍侯......