Postgres Pro
Downloads
Home   >   mailing lists

Re: Error in PostgreSQL query with psycopg - Mailing list pgsql-general

From Harald Armin Massa
Subject Re: Error in PostgreSQL query with psycopg
Date
Msg-id 7be3f35d0607311330n2801cae3u3ccaef26cb47b74e@mail.gmail.com
Whole thread Raw
In response to Error in PostgreSQL query with psycopg  (Parthan <parth.technofreak@gmail.com>)
Responses Re: Error in PostgreSQL query with psycopg  ("John D. Burger" <john@mitre.org>)
List pgsql-general
Tree view
Parthan,

never, never, never try quoting on your own! You can only fail. The only choice is to fail now or later.

The only recommended way with Python and DBAPI2.0 is:

lala="huibuh"
cs.execute ("select bla from foo where schupp=%s", (lala,))

or better

cs.execute ("select bla from foo where schupp=%(lala)s", dict(lala="huibuh"))

(that's with psycopg2)

Harald




--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.

pgsql-general by date:

Previous
From: Christian Kastner
Date:
Subject: Re: pg_xlog not cleaned up
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Corrupted DB? could not open file pg_clog/####