psycopg2 equivalent of mysqldb.escape_string?

sql postgresql psycopg2
AP257 picture AP257 · Sep 29, 2010 · Viewed 22.2k times · Source

I'm passing some values into a postgres character field using psycopg2 in Python. Some of the string values contain periods, slashes, quotes etc.

With MySQL I'd just escape the string with

MySQLdb.escape_string(my_string)

Is there an equivalent for psycopg2?

Answer

piro picture piro · Oct 6, 2010

Escaping is automatic, you just have to call:

cursor.execute("query with params %s %s", ("param1", "pa'ram2"))

(notice that the python % operator is not used) and the values will be correctly escaped.

You can escape manually a variable using extensions.adapt(var), but this would be error prone and not keep into account the connection encoding: it is not supposed to be used in regular client code.

Related questions

Passing table name as a parameter in psycopg2

I have the following code, using pscyopg2: sql = 'select %s from %s where utctime > %s and utctime < %s order by utctime asc;' data = (dataItems, voyage, dateRangeLower, dateRangeUpper) rows = cur.mogrify(sql, data) This outputs: select 'waterTemp, airTemp, …

Read More
PostgreSQL - how to run VACUUM from code outside transaction block?

I am using Python with psycopg2 and I'm trying to run a full VACUUM after a daily operation which inserts several thousand rows. The problem is that when I try to run the VACUUM command within my code I get …

Read More
Graceful Primary Key Error handling in Python/psycopg2

Using Python 2.7 and In [150]: psycopg2.version Out[150]: '2.4.2 (dt dec pq3 ext)' I have a simple python scripts that processing transactions and writes data to a database. Occasionally there is an insert that violates my primary key. This is …

Read More