Problem with strange chars in text filed.

Поиск
Список
Период
Сортировка
Искать
От
Bruce
Тема
Problem with strange chars in text filed.
Дата
Msg-id
CADzTWJnJ-sq9G56ev85q2NZAFVja8sZw645uxONPymqXO_EgBQ@mail.gmail.com
Список
Дерево обсуждения
Problem with strange chars in text filed. Bruce <okbishop@gmail.com>
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>
Re: Problem with strange chars in text filed. Bruce <okbishop@gmail.com>
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 по дате отправления
От: David G Johnston
Дата:
Сообщение: Re: Parameterized Query
От: Rob Sargent
Дата:
FAQ