psycopg2
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 to match strings that start with the string \"20% of all\", so I want to write something li[详细]
2022-12-16 21:34 分类:问答Cancel query execution in pyscopg2
How would one go about cancelling execution of a query statement using pyscopg2 (the python Postgres driver)?[详细]
2022-12-16 13:44 分类:问答Debugging livelock in Django/Postgresql
I run a moderately popular web app on Django with Apache2, mod_python, and PostgreSQL 8.3 with the postgresql_psycopg2 database backend. I\'m experiencing occasional livelock, identifiable when an apa[详细]
2022-12-15 10:52 分类:问答Installing PostgreSQL and pyscopg2 on Snow Leopard
I\'m still a complete beginner in the field of web development and I\'m trying to set up the Django environment. I\'m reading \"the definitive guide to django\" to start my practice.[详细]
2022-12-15 05:12 分类:问答psycopg2 vs sys.stdin.read()
I have small code like below : #!/usr/bin/python import psycopg2, sys try: conn = psycopg2.connect(\"dbname=\'smdr\' user=\'bino\'\");[详细]
2022-12-13 22:52 分类:问答Recreating Postgres COPY directly in Python?
I have a block of data, currently as a list of n-tuples but the format is pretty flexible, that I\'d like to append to a Postgres table - in this case, each n-tuple corresponds to a row in the DB.[详细]
2022-12-13 09:28 分类:问答psycopg2 and mod_python import error
I am trying to setup roundup on a windows XP machine. I use psycopg2 v2.0.13 and when i import the psycopg2 module from the shell it all works fine, but when mod_python tries to do it, I get this erro[详细]
2022-12-09 17:37 分类:问答Generate SQL statements with python [duplicate]
This question already has answers here: How to quote a string value explicitly (Python DB API/Psycopg2)[详细]
2022-12-09 00:04 分类:问答handling db connection on daemonize threads
I have a problem handling database connections in a daemon I\'ve been working on, I first connect to my postgres database with:[详细]
2022-12-08 23:19 分类:问答psycopg2 disconnects from server
I\'ve been tackling this for a while. I setup a completely new machine. I\'ve installed a fresh copy of postgresql and all my other dependencies. Basically, I get these database disconnections at rand[详细]
2022-12-08 01:26 分类:问答