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

From Rob Sargent
Subject Re: Problem with strange chars in text filed.
Date
Msg-id 5395DBC7.9050506@gmail.com
Whole thread Raw
In response to Problem with strange chars in text filed.  (Bruce <okbishop@gmail.com>)
List pgsql-sql
On 06/09/2014 10: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()
    address = fake.address()
    print (meme,address)
    cur.execute("INSERT INTO TRUCK2  VALUES (%s, %s)", ([meme], [address]))
    conn.commit()

Heres what the data looks like:

xcv=# select * from truck2;
         name          |              address
-----------------------+------------------------------------
 {"Hana Mosciski"}     | {"9597 Rosalia Rue                +
                       | South Rossie, AS 22326"}
 {"Paisley Miller"}    | {"588 Lorin Vista                 +
                       | Merlinville, NY 79007"}

Whats up with the {" on each line.

Help

What's up with the '[' deref. in the execute?

pgsql-sql by date:

Previous
From: Bruce
Date:
Subject: Problem with strange chars in text filed.
Next
From: Bruce
Date:
Subject: Fwd: Problem with strange chars in text filed.