Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce
Subject Problem with strange chars in text filed.
Date
Msg-id CADzTWJnJ-sq9G56ev85q2NZAFVja8sZw645uxONPymqXO_EgBQ@mail.gmail.com
Whole thread Raw
Responses Re: Problem with strange chars in text filed.  (Rob Sargent <robjsargent@gmail.com>)
Re: Problem with strange chars in text filed.  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: David G Johnston
Date:
Subject: Re: Parameterized Query
Next
From: Rob Sargent
Date:
Subject: Re: Problem with strange chars in text filed.