Re: Problem with strange chars in text filed. - Mailing list pgsql-sql

On 06/09/2014 09:02 AM, Bruce wrote:

I have a table:
create table truck (name varchar(45),address varchar(150));

doing an insert:
for i in range (0,10):

     meme = fake.name <http://fake.name>()

     address = fake.address()
     print (meme,address)
     cur.execute("INSERT INTO TRUCK2  VALUES (%s, %s)", ([meme], [address]))
     conn.commit()

Assuming you are using psycopg2 the answer is here:

http://initd.org/psycopg/docs/usage.html#passing-parameters-to-sql-queries

so:

cur.execute("INSERT INTO TRUCK2  VALUES (%s, %s)", (meme, address))
or
cur.execute("INSERT INTO TRUCK2  VALUES (%s, %s)", [meme, address])

Help

--
Adrian Klaver
adrian.klaver@aklaver.com