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