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 <http://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?