On 05/11/11 00:12, John Fabiani wrote:
I'm using psycopg2.
OK - bear in mind, I'm not a Python user.
This is what I'm doing from python myvarString = "long string that contains single quotes" cusor.execute("insert into table (pkid, myfield) values (%s, $$%s$$)",(123, myvarString)) When I execute the above I'm seeing: E'long string that contains single quotes' in the field. When I do a "select * from table" I get E'long string that contains single quotes'.
OK, so it seems psycopg is quoting your strings for you (as you'd expect). It's presumably turning your query into:
... values (E'123', $$E'<long string>'$$) So - the $$ quoting is unnecessary here - just use the % placeholders. Incidentally, should it be %s for the numeric argument?
myvarString = "long string that without single quotes" cusor.execute("insert into table (pkid, myfield) values (%s, %s)",(123, myvarString)) I get the following: "long string that without single quotes"
That seems sensible to me (unless there's a typo in your example). You shouldn't need to quote any of your values in your Python code - it's doing it for you. I'm guessing there are other options beside %s for other data-types (integers,floats,boolean etc).
-- Richard Huxton Archonet Ltd -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql