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

That was in the example I had.  Do you think it's what's causing the {" in the table?

On Mon, Jun 9, 2014 at 11:07 AM, Rob Sargent <robjsargent@gmail.com> wrote:

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?